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

189 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
clothier133536(None) 
clothiers1443421clothiers
blotchier1643212blotchier
blottier10336412blottier
cloddier1234062cloddier
cloggier1244252cloggier
clothe114712992cloth_e_
clothed134010282cloth_ed
clothes124513822cloth_es
clothing14278782clothing
cloudier1135052cloudier
cottier93814172c_ottier
couthier13218912couthier
frothier1435952frothier
lathier10310832_lathier
luthier1038232_luthier
mothier121910212_mothier
plottier10327262plottier
sloshier1135282sloshier
toothier1136422toothier
another10289153anoth_er
blather125314213blath_er
blether12459913bleth_er
blither124812173blith_er
blockier1666133blockier
bloodier1136823bloodier
bloomier1275783bloomier
blotter94612853blot_ter
blousier1055663blousier
blowier1248943blo_wier
blowsier1335063blowsier
blowzier2233413blowzier
botchier15287143_botchier
bother115218063_both_er
bothies12414783_bothies
brother123311333broth_er
cahier113615773c__ahier
cashier123713323c_ashier
catchier15329863catchier
cattier93317073c_attier
chattier1337513chattier
chichier1836023chichier
chokier1638043cho_kier
choosier1337183choosier
choppier17286653choppier
cither114616683c_ith_er
clammier1435843clammier
clankier14327083clankier
clasher124615513clash_er
classier10359083classier
clatter94014973clat_ter
clavier1239173cl_avier
clayier1248323cl_ayier
cliffier1633913cliffier
clingier1155853clingier
cliquier1944223cliquier
clobber13378163clo_bber
cloche134312373cloch_e_
cloches144113713cloch_es
clocker153910873clo_cker
clogger11438803clo_gger
cloister1037093cloister
cloner84418093clo__ner
closer84918203clo__ser
cloth105817543cloth___
clothings15264433clothings
clothlike1842663clothlike
cloths115512483cloth__s
clotted104011823clot_ted
clotting113110643clotting
cloture9238453cloture_
clotured11246163clotured
clotures10299023clotures
clouter93511693clo_uter
clover114617123clo__ver
clowder13367943clo_wder
clubbier1434833clubbier
clumpier1435583clumpier
clumsier1234733clumsier
clunkier14345793clunkier
clutter94211663clut_ter
coalier93416183c_oalier
cobbier133410163c_obbier
cockier154013623c_ockier
coheir1137583c_o_heir
collier93618153c_ollier
colter84625093colt__er
comfier1439163c_omfier
cooter85128613coot__er
cootie84223093coot_ie_
cooties93725733coot_ies
copier103722903c_o_pier
corkier133114303c_orkier
cornier93017093c_ornier
cosher114819903c_osh_er
cosier84423763c_o_sier
costlier1038523costlier
cotter84926673c_ot_ter
cottiers10399163c_ottiers
courier93617893c_ourier
couther123914633couth_er
couthie121810553couthie_
cowier113616163c_o_wier
cozier173315143c_o_zier
croakier14436273croakier
crosier94116583cro_sier
croupier1246893croupier
crozier18369943cro_zier
cushier123610833c_ushier
dotier73917033_dot_ier
dottier83910923_dottier
drouthier1343033drouthier
earthier1137443earthier
filthier1434073filthier
flashier1437103flashier
fleshier1435603fleshier
floatier1136983floatier
flockier1745343flockier
floppier1554633floppier
flossier11326973flossier
flutier103011553flut_ier
flytier13356503flyt_ier
footier104115113foot_ier
frother133110153froth_er
glitchier1542793glitchier
glitzier1833593glitzier
globbier1334243globbier
gloomier1135093gloomier
gloppier1354673gloppier
glossier9358203glossier
grottier9316673grottier
growthier1642203growthier
heathier1438343heathier
hootier104915353hoot_ier
joltier14318493jolt_ier
klutzier2142193klutzier
knottier12203983knottier
lather95124363_lath_er
lither94520953_lith_er
loamier9349163_loamier
loather103711003_loath_er
loftier1037763_loftier
loggier93811143_loggier
logier75015733_lo_gier
loonier73312683_loonier
loopier93711193_loopier
loppier11369723_loppier
lotter64025603_lot_ter
lousier72411623_lousier
lowlier10338903_lowlier
luthiers1135163_luthiers
mother113718643_moth_er
motlier92010583_motlier
mouthier13208173mouthier
mythier15125183_mythier
nother93815963_noth_er
other84219103__oth_er
pithier123010293_pithier
plashier1337613plashier
platier93716293plat_ier
plotter94113663plot_ter
plotties103111413plotties
plushier1375193plushier
pother113818853_poth_er
pottier93516493_pottier
rootier74915393root_ier
slather103816083slath_er
slatier74016813slat_ier
slither104112983slith_er
slittier837003slittier
slobbier1254633slobbier
sloppier1255713sloppier
slotter73314453slot_ter
slouchier1443603slouchier
sloughier1343673sloughier
slushier1135983slushier
sluttier836453sluttier
smother123510213smoth_er
snottier8217383snottier
soother104215043sooth_er
sootier73916613soot_ier
splotchier1741933splotchier
spottier10207313spottier
tother94117143_toth_er
withier132910493_withier
worthier1436713worthier
wrathier1435903wrathier
zloties1639913zlot_ies
zootier163611173zoot_ier

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621898.12617987.0
3Display Results1891890.0802362.5
 (SQL Overall)1786911898.62620715.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.