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

165 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
clubbier143483(None) 
chubbier1733891chubbier
clubber13319591clubb_er
blubber10399292blubb_er
clabber134210112clabb_er
clobber13378162clobb_er
clubbed14307452clubb_ed
clubbers14378582clubb_ers
clubbiest1534272clubbiest
clubbing15266512clubbing
clubbish1743812clubbish
clumber134011442clumb_er
clumpier1435582clumpier
clumsier1234732clumsier
clunkier14345792clunkier
cobbier133410162c_obbier
crabbier14326802crabbier
crumbier1456362crumbier
cubbies133312882c_ubbies
flabbier1534092flabbier
flubber14287712flubb_er
globbier1334242globbier
grubbier13344752grubbier
knubbier1642512knubbier
lubber104214622_lubb_er
nubbier11308132_nubbier
scrubbier1543332scrubbier
slobbier1254632slobbier
slubber113010762slubb_er
snubbier1244992snubbier
stubbier1235352stubbier
tubbier11237742_tubbier
blabber10418923blabb_er
blubbed11338393blubb_ed
blubberer12173453blubberer
blubbers11408143blubb_ers
blubbery14294783blubb_ery
blubbing12257013blubbing
bluesier1034943bluesier
blurrier1035163blurrier
bubbies103913513_bubbies
bubbler103611783_bubbler
bubblier1184473_bubblier
cabbie122913353c_abbie_
cabbies133115163c_abbies
catbrier1236173catbrier
chubbiest1843753chubbiest
chubbily2042913chubbily
chuffier1934543chuffier
chummier1734513chummier
chunkier17395883chunkier
clabbers14359903clabb_ers
clamber133311743clamb_er
clammier1435843clammier
clankier14327083clankier
classier10359083classier
clavier1239173cl_avier
clayier1248323cl_ayier
cliffier1633913cliffier
climber13449133climb_er
clingier1155853clingier
cliquier1944223cliquier
clobbers14397513clobb_ers
cloddier1234063cloddier
cloggier1244253cloggier
clothier1335363clothier
cloudier1135053cloudier
clubable1436093clubable_
clubbiness1642993clubbiness
clubby1534683clubb__y
clubfeet1543793clubfeet
clubmen1334253clu_bmen
clumbers143910413clumb_ers
clunker13419453clu_nker
cluster94013333clu_ster
clutter94211663clu_tter
cobber124116843c_obb_er
cobbler133311823c_obbler
courier93617893cou_rier
courtier1059333courtier
couthier13218913couthier
crabber133810733crabb_er
cribber13367663cribb_er
cruddier1244153cruddier
crumber13339643crumb_er
crumblier1543873crumblier
crummier1435603crummier
crustier10259533crustier
cubbish1635803c_ubbish
cuber95222533c_u_b_er
cumber124016703c_umb_er
cuppier1368323c_uppier
curber104517053c_urb_er
curdier103312623c_urdier
curlier93314183c_urlier
currier93316703c_urrier
curvier123110663c_urvier
cushier123610833c_ushier
daubier1037103dau_bier
drubber12357863drubb_er
dubber113814553_dubb_er
flubbed15306633flubb_ed
flubbers15346893flubb_ers
flubbing16275883flubbing
fluffier13264333fluffier
flukier14397853flu_kier
flutier103011553flu_tier
fubsier12367763_fubsier
gabbier12379633_gabbier
glibber1235163glibb_er
gluier7310263glu__ier
glumpier1334873glumpier
grabbier13316653grabbier
grubber12417913grubb_er
hubbies143211563_hubbies
kludgier1432463kludgier
klutzier2142193klutzier
knobbier1652703knobbier
lambier113611643_lambier
libber104414013_libb_er
limbier11349113_limbier
lobber104016603_lobb_er
lobbied12337173_lobbied
lobbies113612463_lobbies
lobbyer1433913_lobbyer
lubbers113913723_lubb_ers
luckier133811533_luckier
lumber103817773_lumb_er
lumpier113410143_lumpier
lunier64617603_lu_nier
lustier73813503_lustier
luthier1038233_luthier
nobbier11309163_nobbier
nubblier1254413_nubblier
pluckier16295073pluckier
plumber13339983plumb_er
plumier113510043plu_mier
plummier1434123plummier
plunkier14305323plunkier
plushier1375193plushier
ribbier1137593_ribbier
rubber104715793_rubb_er
rubbies114114113_rubbies
rubblier1244913_rubblier
rubier84814743_ru_bier
scabbier1435133scabbier
scrubber1434113scrubb_er
shabbier1535183shabbier
shrubbier1642193shrubbier
slabber113311393slabb_er
slobber11388903slobb_er
slubbed12339283slubb_ed
slubbers12349943slubb_ers
slubbing13248033slubbing
sludgier1034823sludgier
slumber113811003slumb_er
slummier1235473slummier
slushier1135983slushier
sluttier836453sluttier
snobbier1234633snobbier
snubber11277733snubb_er
squabbier2242753squabbier
stubblier1343203stubblier
tubber104313203_tubb_er
webbier1445423_webbier

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.1561145455.1
2DLD Change Limit1461621657.08020644.4
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.29624491.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.