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

159 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
studlier93547(None) 
studier82510051stud_ier
loudlier934952loudlier
sludgier1034822sludgier
smudgier1233752smudgier
steelier839192steelier
stillier868822stillier
stodgier1034222stodgier
stubbier1235352stubbier
stubblier1343202stubblier
studdie9195272studdie_
studdies10207072studdies
studied9268692stud_ied
studiers9236622stud_iers
studies82413862stud_ies
studliest1036572studliest
stuffier14336622stuffier
stumpier1255882stumpier
sturdier9216962sturdier
sudsier868782s_udsier
surlier72915442s_urlier
atelier7311623at_elier
bullier94116433_bullier
burlier93514413_burlier
cruddier1244153cruddier
cuddlier1234013cuddlier
curlier93314183_curlier
deadlier1036863deadlier
drumlier1134523drumlier
gaudier938453gaud_ier
gladlier1034343gladlier
godlier938893_godlier
goodlier1035793goodlier
haulier1059943hau_lier
kindlier1345763kindlier
kludgier1432463kludgier
knurlier1242883knurlier
lordlier935363lordlier
mouldier1154963mouldier
muddier114110023_muddier
outlier72216143_outlier
puddlier1234213puddlier
pudgier11377723_pudgier
ruddier9338523_ruddier
rulier65016353_ru_lier
saddler93811963saddl_er
sallier73320423s_allier
sandier84017843sand_ier
saucier9810283sau_cier
scalier94316913s_calier
sculker13318323scu_lker
sculler99812153scu_ller
scummier1445083scummier
scurfier13267053scurfier
scurvier13255883scurvier
scuzzier1842713scuzzier
sedgier9399053s_edgier
seedier83513633seed_ier
seemlier1035193seemlier
shadier113111153shad_ier
shalier103116423s_halier
shellier1138393shellier
shoalier1137073shoalier
shoddier1334213shoddier
shudder12297323shud_der
sicklier1457213sicklier
sidler74716963s_idl_er
sillier74017593s_illier
skiddier1464193skiddier
skulker10325683sku_lker
skunkier11174283skunkier
slier54827243s___lier
slummier1235473slummier
slushier1135983slushier
sluttier836453sluttier
smellier1036793smellier
smuttier1035213smuttier
snarlier8278183snarlier
snubbier1244993snubbier
snuffier14276943snuffier
snufflier1543303snufflier
soldier82812153sold_ier
soupier93111753sou_pier
spindlier1253873spindlier
spudder11256553spud_der
spumier1137903spu_mier
spunkier14235823spunkier
spurrier10297693spurrier
squalider1943843squalider
squaller1736083squaller
squallier1844363squallier
stabler94014933stabl_er
staggier10167513staggier
stagier83513443st_agier
staler64025823st_al_er
stalker113912253st_alker
stalkier1257073stalkier
stapler93913633stapl_er
starrier8279463starrier
statelier945653statelier
steadier937313steadier
stealer72913983steal_er
steamier1048303steamier
steelie7310213steelie_
steelies8312553steelies
stemmier1245253stemmier
stickier14229763stickier
stifler102911473stifl_er
stiller73414303st_iller
stingier9279123stingier
stinkier12278543stinkier
stockier14217253stockier
stolider936603st_olider
stonier72013793st_onier
stoolie739723stoolie_
stoolies8311083stoolies
stormier1036103stormier
strawier1137493strawier
stripier1058863stripier
stroller848183stroller
stuccoer1252803stuccoer
studded10236873stud_ded
studding1136703studding
studfish1544523studfish
studio7247133stud_i_o
studios8256643stud_ios
studly10397693studl__y
studying1335553studying
stuffer13349793stu_ffer
stuiver10447083stu_iver
stumbler1235813stumbler
stumper113610093stu_mper
stunner7349193stu_nner
stupefier1442653stupefier
stupider1133913stupider
sturdied10215963sturdied
sturdies92110273sturdies
stutter72911463stu_tter
styler94013303st_yl_er
styliser11185523st_yliser
stylizer20185443st_ylizer
sublimer1237613s_ublimer
suckier133613973s_uckier
sudser73511283s_ud_ser
sulker104015923s_u_lker
sulkier113811963s_ulkier
sullied83714483s_ullied
sullies74122233s_ullies
sunnier73412153s_unnier
supplier1246603supplier
surfier102613543s_urfier
sutler63718393s_utl_er
swirlier1135213swirlier
tallier72817213_tallier
tidier73515113_tid_ier
tubbier11237743_tubbier
tuftier1096603_tuftier
turfier10249793_turfier
uglier748953__uglier

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.470380193.6
2DLD Change Limit1461621597.97018339.0
3Display Results1591590.0602650.0
 (SQL Overall)1786911598.50021022.5
 
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.