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 “nestlings” 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.

133 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
nestlings107431(None) 
nestling958891nestling_
fettlings1353752fettlings
jestings16368022jest_ings
needlings11294692needlings
nesting84320442nest_ing_
nettings9288102ne_ttings
nettling957212nettling_
pestling111010252pestling_
restrings10159292restrings
settlings1054682settlings
vestings12359142vest_ings
westings12429802west_ings
wrestlings1442932wrestlings
bantlings12216603bantlings
bastings114214693bast_ings
beastings12387653beast_ings
beatings114113233beat_ings
beestings12335923beest_ings
beetling1139283beetling_
bellings113811153be_llings
beltings11369253belt_ings
beltlines1135963beltlines
besting104923923best_ing_
biestings12266033biest_ings
bottlings12215293bottlings
bustlines11207353bustlines
bustling112110063bustling_
castings113614053cast_ings
castling11311233castling_
catlings113712043_catlings
ceilings11397993ce_ilings
centrings12227603centrings
chitlings15255903chitlings
crestings12298043crest_ings
dealings103510703de_alings
destains9311813destain_s
destines93619663dest_ines
dieselings1252933dieselings
dustings10419033dust_ings
eanlings9128473_eanlings
eastings93412953east_ings
eatings84616443_eat_ings
ensiling9410723ensiling_
estrins7315853_estrin_s
eyestrings1462773eyestrings
fastings124011943fast_ings
fatlings12359303_fatlings
feelings12338933fe_elings
feltings12317903felt_ings
fettling1266773fettling_
firstlings1442523firstlings
flatlings13315823flatlings
gentling1048453gentling_
goslings10297553gos_lings
heelings12359753he_elings
hustings12378683hust_ings
hustling12228793hustling_
jesting154317713jest_ing_
jostling16207123jostling_
justling16207253justling_
keglings14245233ke_glings
kitlings13318103_kitlings
lastings94214423last_ings
listings93310043list_ings
lustrings10245553lustrings
mantlings12207233mantlings
meetings11287413meet_ings
mestinos1048163mest_inos
naethings1343873naethings
neckings15346113ne_ckings
necklines15115723necklines
needling10248753needling_
nervings12256323ne_rvings
nestlers8359233nestl_ers
nestles73015463nestl__es
nestlike1236083nestli_ke
netting84018763ne_tting_
neutrinos943823neutrinos
nigglings12213733nigglings
northings13185573northings
nosings8349593nos__ings
nothings12266683n_othings
nurslings1043733nurslings
nuttings9276783n_uttings
oestrins8312673oestrin_s
peelings11339523pe_elings
pettings11349703pe_ttings
pettling1168213pettling_
postings112912303post_ings
rattlings10235513rattlings
reedlings11236343reedlings
reelings94012563re_elings
resiling93520173resiling_
resilins83013373resilin_s
resittings11264553resittings
resoling92916303resoling_
resprings12156253resprings
resting85031183rest_ing_
restring91518783restring_
restyling1337923restyling_
rieslings1034493ries_lings
rustling9249983rustling_
seatings93614303seat_ings
seedlings11195953seedlings
sestinas8249133sest_inas
sestines82717243sest_ines
setlines8312743se_tlines
settings93810073se_ttings
settling978943settling_
slings74618013__s_lings
stings76220183__st_ings
strings84617133__strings
stylings12276233__stylings
teethings1344233teethings
testing86021053test_ing_
turtlings10184873turtlings
unslings937283uns_lings
unstrings1046013unstrings
veilings12357313ve_ilings
vesting114618683vest_ing_
weaklings1794003weaklings
weanlings1394413weanlings
weltings12388203welt_ings
westing115020273west_ing_
wettings12348403we_ttings
whistlings1742913whistlings
witlings12328443_witlings
wrestling1336063wrestling_
yealings12257703ye_alings
yeanlings1393693yeanlings
yearlings1384203yearlings
zesting174515333zest_ing_

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.436409841.7
2DLD Change Limit1486411337.03021143.8
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.52923733.7
 
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.