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

169 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
stubbier123535(None) 
snubbier1244991snubbier
stubblier1343201stubblier
tubbier11237741_tubbier
chubbier1733892chubbier
clubbier1434832clubbier
grubbier13344752grubbier
knubbier1642512knubbier
nubbier11308132_nubbier
scabbier1435132scabbier
scrubbier1543332scrubbier
shabbier1535182shabbier
shrubbier1642192shrubbier
slobbier1254632slobbier
slubber113010762slubb_er
snobbier1234632snobbier
snubber11277732snubb_er
squabbier2242752squabbier
stabber113610152stabb_er
stubbed12378082stubb_ed
stubbiest1345482stubbiest
stubbily1564242stubbily
stubbing13237452stubbing
stubble1136842stubble_
stubbled1385072stubbled
stubbles1236842stubbles
studier82510052stu_dier
studlier935472studlier
stuffier14336622stuffier
stumbler1235812stumbler
stumpier1255882stumpier
sturdier9216962sturdier
tubber104313202_tubb_er
blubber10399293blubb_er
bubbies103913513_bubbies
bubbler103611783_bubbler
bubblier1184473_bubblier
clubber13319593clubb_er
cobbier133410163_cobbier
crabbier14326803crabbier
crumbier1456363crumbier
cubbies133312883_cubbies
daubier1037103dau_bier
drubber12357863drubb_er
dubber113814553_dubb_er
flabbier1534093flabbier
flubber14287713flubb_er
fubsier12367763_fubsier
gabbier12379633_gabbier
globbier1334243globbier
grabbier13316653grabbier
grubber12417913grubb_er
hubbies143211563_hubbies
knobbier1652703knobbier
lubber104214623_lubb_er
nobbier11309163_nobbier
nubblier1254413_nubblier
ribbier1137593_ribbier
rubber104715793_rubb_er
rubbies114114113_rubbies
rubblier1244913_rubblier
rubier84814743_ru_bier
saucier9810283sau_cier
scrubber1434123scrubb_er
scummier1445083scummier
scurfier13267053scurfier
scurvier13255883scurvier
scuzzier1842713scuzzier
skunkier11174283skunkier
slabber113311393slabb_er
slobber11388903slobb_er
slubbed12339283slubb_ed
slubbers12349943slubb_ers
slubbing13248033slubbing
sludgier1034823sludgier
slumber113811003slumb_er
slummier1235473slummier
slushier1135983slushier
sluttier836453sluttier
smudgier1233753smudgier
smuttier1035213smuttier
snubbed12347443snubb_ed
snubbers12326673snubb_ers
snubbiest1345073snubbiest
snubbing13236673snubbing
snuffier14276943snuffier
sobber104016593s_obb_er
soupier93111753sou_pier
spumier1137903spu_mier
spunkier14235823spunkier
spurrier10297693spurrier
squabbler2242733squabbler
stabbed123510373stabb_ed
stabbers12268733stabb_ers
stabbing13238763stabbing
stabler94014933st_abler
staggier10167513staggier
stagier83513443st_agier
stalkier1257073stalkier
starrier8279463starrier
steadier937313steadier
steamier1048303steamier
steelier839193steelier
stemmier1245253stemmier
stickier14229763stickier
stillier868823stillier
stingier9279123stingier
stinkier12278543stinkier
stobbed12287493stobb_ed
stobbing13227243stobbing
stockier14217253stockier
stodgier1034223stodgier
stonier72013793st_onier
stormier1036103stormier
strawier1137493strawier
stripier1058863stripier
stubbliest1453343stubbliest
stubbly1444473stubb_ly
stubborn1242883stubborn
stubborner1451683stubborner
stubby1345043stubb__y
stuccoer1252803stuccoer
studdie9195273studdie_
studdies10207073studdies
studied9268693stu_died
studiers9236623stu_diers
studies82413863stu_dies
stuffer13349793stu_ffer
stuiver10447083stu_iver
stumble1147553stumble_
stumbled1335623stumbled
stumblers1334383stumblers
stumbles1237493stumbles
stumper113610093stu_mper
stunner7349193stu_nner
stupefier1442653stupefier
stupider1133913stupider
sturdied10215963sturdied
sturdies92110273sturdies
stutter72911463stu_tter
subbed114116673s_ubb_ed
subbing123915583s_ubbing
subduer10107033s_ubduer
suber74924503s_u_b_er
sublimer1237613s_ublimer
subsider1138243s_ubsider
subtiler10208573s_ubtiler
subtler92910843s_ubtler
suckier133613973s_uckier
sudsier868783s_udsier
sulkier113811963s_ulkier
sunnier73412153s_unnier
surfier102613543s_urfier
surlier72915443s_urlier
swabber14297963swabb_er
swabbie1484333swabbie_
swabbies15115713swabbies
swobber14336543swobb_er
tabbied12297793_tabbied
tabbies112913503_tabbies
tubbed114712223_tubb_ed
tubbers113411253_tubb_ers
tubbiest12117293_tubbiest
tubbing123510093_tubbing
tuber75420683_tu_b_er
tuftier1096603_tuftier
tumbler113412823_tumbler
turfier10249793_turfier
webbier1445423_webbier

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.423422437.4
2DLD Change Limit1461621697.64019131.2
3Display Results1691690.0632682.5
 (SQL Overall)1786911698.12621990.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.