Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “plannings” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

148 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
plannings1232545(None) 
plankings16326111plankings
planning113610221planning_
plantings12348401plantings
cannings113710332_cannings
landings103110072_landings
panning104019392p_anning_
plaining113911552plaining_
plaitings12296242plaitings
planing103418252pla_ning_
planking153513012planking_
planting113515382planting_
platings113611362pla_tings
scannings12264822scannings
tannings9268632_tannings
alanines8314803ala_nines
alanins7315803ala_nin_s
antings85015583__antings
awnings11406713__awnings
bankings15489403_bankings
banning103818233_banning_
blackings18316763blackings
bladings12337753bla_dings
blaggings14324463blaggings
blanking154411933blanking_
blastings12347913blastings
blazonings2241983blazonings
brandings13277483brandings
branning112911093branning_
canning103620133_canning_
claddings1433213claddings
clanging124012123clanging_
clanking154313063clanking_
clonings11307433cl_onings
cunnings11357343_cunnings
darnings10378553_darnings
eanlings9128473_eanlings
earnings9419333_earnings
fanning113615073_fanning_
flaggings15285183flaggings
flanging132710583flanging_
flanking164211083flanking_
flashings16316663flashings
flatlings13315823flatlings
ginnings10366523_ginnings
glancing1247063glancing_
glazings19325753gla_zings
gleanings11244643gleanings
gunnings10346733_gunnings
hangings13258583_hangings
innings8329443__innings
kennings13315273_kennings
lacings105013653_la_cings
ladings93814133_la_dings
laggings11298403_laggings
lakings124713513_la_kings
lancing103314123_lancing_
landing92819323_landing_
lapwings14274973_lapwings
lashings124412253_lashings
lastings94214423_lastings
lathings12469853_lathings
lawings113611473_la_wings
leanings94010183_leanings
learnings1094323learnings
linings84313073_l_inings
loanings9348013_loanings
longings10408563_longings
manning103616383_manning_
meanings11329163mea_nings
packings174310063p_ackings
paddings13297013p_addings
pagings114411063p_a_gings
paining103920243p_aining_
paintings12327093paintings
pairings11398313p_airings
palings103915823p_a_lings
panelings12107453p_anelings
panging113319113p_anging_
panniers10488853p_anniers
panting104025423p_anting_
pargings123410163p_argings
parings104219213p_a_rings
parkings153610683p_arkings
partings113513733p_artings
passings11409873p_assings
pavings134011633p_a_vings
pawning134711413p_awning_
pennines103112043p_ennines
penning103616493p_enning_
pfennigs1461983pfenni_gs
pharmings17254723pharmings
pinkings15338143p_inkings
pinning103417853p_inning_
placing123815283pla_cing_
plaguing1236033plaguing_
plains85019593pla__in_s
plainsongs1351653plainsongs
plaints94012053pla__ints
plaiting113113513plaiting_
planners10399933plann_ers
plantains1147493plantain_s
plashing143311063plashing_
plasmins12199413plasmin_s
platinas103610313pla_tinas
plating103823073pla_ting_
platting114813033platting_
playgoings1792373playgoings
playing133816093pla_ying_
playthings1942363playthings
pleadings13285543pleadings
plinking153611243plinking_
plonking15358563plonking_
plumbings16213363plumbings
plunging12357673plunging_
plunking15328483plunking_
prancing132612163prancing_
pranging123012723pranging_
pranking153813383pranking_
prawning1446963prawning_
printings12268103printings
punning103414993p_unning_
rankings13389173_rankings
replanning1345313replanning_
runnings9326913_runnings
scanning113310773scanning_
slammings14234123slammings
slanging103413433slanging_
slanting94115093slanting_
slashings13316203slashings
slatings94011723sla_tings
slattings10346073slattings
spankings16215003spankings
spanning113311083spanning_
spinnings12294853spinnings
standings11257153standings
swanning12338813swanning_
tanning83618253_tanning_
tannins72813223_tannin_s
trainings10246723trainings
twinnings13253663twinnings
vanning113912463_vanning_
wanning113816213_wanning_
warnings12358453_warnings
weanlings1394413weanlings
winnings12327583_winnings
yeanlings1393693yeanlings
yearnings1393553yearnings

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.406440125.6
2DLD Change Limit1486411487.01321195.1
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.48223882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.