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

138 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
claddings143321(None) 
cladding1337141cladding_
bladings12337752bla_dings
cardings123812642c_ardings
gladding1236302gladding_
ladings93814132_la_dings
landings103110072_landings
paddings13297012_paddings
sleddings12263782sleddings
waddings14356472_waddings
adding93914963__adding_
audings9289393__audings
beadings123711783bea_dings
beddings13407923_beddings
biddings13397563_biddings
blackings18316763blackings
blading113615363bla_ding_
blaggings14324463blaggings
blastings12347913blastings
bleedings13264643bleedings
bloodings13245273bloodings
boardings13296063boardings
bradding13268933bradding_
braidings13285903braidings
brandings13277483brandings
buddings13326653_buddings
caddices14297853c_addices
caddies113718383c_addi_es
caddis104613383c_addi__s
caddises12329353c_addises
caddying16225063c_addying_
cadging123610973c_adging_
calkings15289223c_alkings
callings113613833c_allings
campings154010203c_ampings
cannings113710333c_annings
cappings15369493c_appings
carding113922443c_arding_
carlings114015863c_arlings
carpings133812393c_arpings
carvings143810213c_arvings
casings104013513c_a_sings
castings113614053c_astings
catlings113712043c_atlings
cavings134712543c_a_vings
celandines1344843celandines
chasings14318253cha_sings
clacking173313493clacking_
claddagh1641193cladd_agh
claddaghs175953claddaghs
cladisms1336093cla_disms
cladists1136723cla_dists
clagging13328883clagging_
claiming13279303claiming_
clamming15329373clamming_
clamping154011153clamping_
clanging124012123clanging_
clangs95113613cla___ngs
clanking154313063clanking_
clapping153810603clapping_
clashing143812193clashing_
clasping133310263clasping_
classing113211793classing_
clawing133812673cla_wing_
claying133614303cla_ying_
clearings12286063clearings
clearwings1651703clearwings
clings95716213cl___ings
clippings16273753clippings
clonings11307433cl_onings
closings11277673cl_osings
clothings15264433clothings
clouding12269493clouding_
coamings13349293coa_mings
coastings12357863coastings
coatings113811843coa_tings
codding124014693c_odding_
codlings123110103c_odlings
cordings123011363c_ordings
crackings18346843crackings
cradling122411453cradling_
cravings14428223cra_vings
crudding1335723crudding_
fadings12469303_fa_dings
flaggings15285183flaggings
flashings16316663flashings
flatlings13315823flatlings
gadding113411453_gadding_
gladdens11364463gladden_s
glazings19325753gla_zings
headings133510493hea_dings
hoardings14315113hoardings
lacings105013653_la_cings
laddies93715053_laddi_es
lading84227123_la_ding_
ladinos8389963_la_dinos
ladling92813393_ladling_
laggings11298403_laggings
lakings124713513_la_kings
landing92819323_landing_
lapwings14274973_lapwings
larding92917873_larding_
lashings124412253_lashings
lastings94214423_lastings
lathings12469853_lathings
lauding93211903_lauding_
lawings113611473_la_wings
leadings103511243_leadings
lidding103611433_lidding_
loadings10378383_loadings
lodgings11336243_lodgings
lordings10368503_lordings
madding123711993_madding_
padding123412513_padding_
paddlings14224363_paddlings
plaitings12296243plaitings
plankings16326113plankings
plannings12325453plannings
plantings12348403plantings
platings113611363pla_tings
pleadings13285543pleadings
plodding13166343plodding_
puddings13325503_puddings
quadding2035363quadding_
radding103715003_radding_
readding11411363readding_
readings103512643rea_dings
recladding1543973recladding_
shadings13327433sha_dings
slammings14234123slammings
slashings13316203slashings
slatings94011723sla_tings
slattings10346073slattings
sledding11248503sledding_
standings11257153standings
studdings1242933studdings
wadding133711943_wadding_
weddings14355533_weddings

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.423422437.4
2DLD Change Limit1486411387.39020113.8
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.87622688.0
 
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.