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 “ladings” with Change Limit: [1] [2]

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

104 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
ladings9381413(None) 
bladings12337751bladings
fadings12469301fadings
lacings105013651lacings
lading84227121lading_
ladinos8389961ladinos
lakings124713511lakings
landings103110071landings
lawings113611471lawings
leadings103511241leadings
loadings10378381loadings
agings86312672_agings
audings9289392audings
bakings144312022bakings
beadings123711782beadings
blading113615362blading_
bodings113711652bodings
cardings123812642cardings
casings104013512casings
cavings134712542cavings
claddings1433212claddings
darings93713652darings
dings76331402__dings
earings84517712earings
eatings84616442eatings
endings92910442endings
facings134511262facings
fading114821112fading_
gamings114610912gamings
gatings95212822gatings
glazings19325752glazings
hading113922942hading_
hayings14379392hayings
hazings20378342hazings
headings133510492headings
hidings12349702hidings
jading154214022jading_
lacing94626232lacing_
ladens74516232laden_s
ladies75124882ladi_es
ladino73615122ladin_o
ladling92813392ladling_
laggings11298402laggings
laking115027042laking_
laminas93615872laminas
laming94528362laming_
landing92819322landing_
lapins84520682lapin_s
lapwings14274972lapwings
larding92917872larding_
lashings124412252lashings
lasing74727982lasing_
lastings94214422lastings
lathings12469852lathings
latinas74416462latinas
latinos73613802latinos
lauding93211902lauding_
laving104623572laving_
lawines103313562lawines
lawing104625282lawing_
laying104525702laying_
layins93817652layin_s
lazing164821472lazing_
leading93419552leading_
leanings94010182leanings
leasings9379842leasings
leavings12407492leavings
likings12539412likings
lings67135772l__ings
linings84313072linings
livings11408922livings
loading94114612loading_
loanings9348012loanings
lodgings11336242lodgings
lordings10368502lordings
losings82810622losings
lowings113710072lowings
lutings83311052lutings
lyings10488502l_yings
makings145413162makings
matings104516212matings
mayings134410512mayings
paddings13297012paddings
pagings114411062pagings
palings103915822palings
parings104219212parings
pavings134011632pavings
platings113611362platings
pleadings13285542pleadings
racings105015132racings
ratings84217412ratings
ravings114614502ravings
readings103512642readings
ridings93412092ridings
savings114412952savings
sayings113610832sayings
shadings13327432shadings
sidings94011462sidings
slatings94011722slatings
takings124512572takings
tidings93810262tidings
waddings14356472waddings
wading114619532wading_
waxings18366452waxings

Search took 4 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 Filter1786911076710.360496363.9
2DLD Change Limit1076711042.93636672.7
3Display Results1041040.0462260.9
 (SQL Overall)1786911043.34253468.3
 
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.