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

114 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
cloturing124547(None) 
closuring1255171closuring
clouring112811271clo_uring
capturing1436622capturing
clothing14278782clot_hing
clotting113110642clot_ting
clouding12269492clo_uding
clouting113011682clo_uting
colouring1258732colouring
culturing1236552culturing
flouring123010142flo_uring
louring83916502_lo_uring
accoutring1543623accoutring
alluring939073al_luring
altering91917113al_tering
blotching1734963blotching
blotting113910433blot_ting
blousing1138793blo_using
cantering122417373cantering
catering112019903c_atering
censuring1237603censuring
centering122915143centering
centring112112953cent_ring
choiring14279793cho_iring
choring133617663cho__ring
chorusing15246113chorusing
chousing14259423cho_using
cincturing1554263cincturing
clamoring1477423clamoring
clamouring15104773clamouring
clattering13109233clattering
clavering1538373clavering
clearing113014883cl_earing
cliquing2035363cliqu_ing
cloaking15299713clo_aking
clobbering17103933clobbering
clocking174312413clo_cking
clogging13368503clo_gging
cloistering1444823cloistering
clomping15329653clo_mping
cloning103215473clo__ning
clonking153810153clo_nking
clopping153511083clo_pping
closeting1236183closeting
closing103114843clo__sing
clothings15264433clot_hings
cloture9238453clotur__e
clotured11246163clotur_ed
clotures10299023clotur_es
clowning14307253clo_wning
cloying133511753clo__ying
clueing104110093cl__ueing
cluing93913503cl__u_ing
clustering13116813clustering
clutching17154823clutching
cluttering13106833cluttering
cohering142413833c_ohering
collaring12310543collaring
colluding1335903colluding
coloring11414843c_oloring
conjuring1937913conjuring
contouring1347013contouring
contusing1239143contusing
coopering142611323coopering
coring94433963c_o__ring
costuming1445283costuming
coting94629253c_ot__ing
coturnix1742203c_oturnix
couping124317023c_o_uping
coursing113112023c_o_ursing
courting112514573c_o_urting
covering142215723c_overing
cowering142514033c_owering
cratering12312653cratering
curing94824783c___uring
detouring1136973detouring
featuring1337323featuring
flooring12259883flo_oring
flouting122610473flo_uting
flowering1636053flowering
gesturing1136653gesturing
glouting10379693glo_uting
glowering1435653glowering
lecturing1237303lecturing
loitering1039683_loitering
lotting82917753_lot_ting
louping104313983_lo_uping
lousing83817733_lo_using
louting83719383_lo_uting
lowering122210913_lowering
luring73820753_l__uring
maturing1139953_maturing
motoring11410953_motoring
nurturing1045013nurturing
outring84021023__outring
pasturing1238433pasturing
picturing1436033picturing
plotting113011013plot_ting
plotzing20276153plot_zing
posturing1238993posturing
pouring103115863_po_uring
procuring1437993procuring
rapturing1245353rapturing
rupturing1244353rupturing
scouring112810853sco_uring
sculpturing1652163sculpturing
slotting92612613slot_ting
souring83219063_so_uring
suturing9310373_suturing
texturing1735223texturing
torturing1036253torturing
touring82915193_to_uring
venturing1337553venturing
vesturing1337203vesturing

Search took 7 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.440406115.9
2DLD Change Limit1486411146.39023261.5
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.87625987.6
 
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.