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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
klutzier214219(None) 
flutier103011552flut_ier
glitzier1833592glitzier
kludgier1432462kludgier
klutzes2064112klutz_es
klutziest2242802klutziest
luthier1038232_luthier
sluttier836452sluttier
blitzer18447663blitz_er
blottier10336413blottier
blowzier2233413blowzier
bluesier1034943bluesier
blurrier1035163blurrier
clothier1335363clothier
clubbier1434833clubbier
clumpier1435583clumpier
clumsier1234733clumsier
clunkier14345793clunkier
clutter94211663clut_ter
couthier13218913couthier
ditzier17307963_ditzier
fluffier13264333fluffier
flukier14397853flu_kier
fluter95316863flut__er
flutter104012093flut_ter
flytier13356503flyt_ier
furzier19318103_furzier
fuzzier18256523_fuzzier
gauzier1735633gau_zier
glazier17409353gl_azier
gluier7310263glu__ier
glumpier1334873glumpier
goutier82612353gout_ier
gutsier8389823_gutsier
guttier83911103_guttier
klezmer2231933kl_ezmer
klutz1868853klutz___
klutziness2342273klutziness
klutzy2243003klutz__y
knottier12203983knottier
knubbier1642513knubbier
knurlier1242883knurlier
kreutzer2141273kreutz_er
lathier10310833_lathier
lazier154214613_l_azier
luckier133811533_luckier
lumpier113410143_lumpier
lunier64617603_lu_nier
lustier73813503_lustier
luthiers1135163_luthiers
lutzes153711923_lutz_es
mouthier13208173mouthier
muzzier17326553_muzzier
nutsier7329253_nutsier
nuttier73112023_nuttier
outlier72216143_outlier
platier93716293plat_ier
plottier10327263plottier
pluckier16295073pluckier
plumier113510043plu_mier
plummier1434123plummier
plunkier14305323plunkier
plushier1375193plushier
poutier93215323pout_ier
puttier93314503_puttier
ritzier16297203_ritzier
ruttier73412283_ruttier
scuzzier1842713scuzzier
slatier74016813slat_ier
sleazier1735123sleazier
slittier837003slittier
sludgier1034823sludgier
slummier1235473slummier
slushier1135983slushier
smuttier1035213smuttier
sultrier837773sultrier

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 Filter1786911461620.420425454.8
2DLD Change Limit146162766.81321453.4
3Display Results76760.0302533.3
 (SQL Overall)178691767.26324602.9
 
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.