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 “southern” 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
southern1143891(None) 
souther104116301souther_
southerns12347211southerns
southers114214451southers
couther123914632couther_
luthern1037652_luthern
mouther123812812mouther_
mouthers133811302mouthers
northern1145582northern
scouther1356942scouther_
scouthers1445992scouthers
soother104215042soother_
soothers113913432soothers
souter64225922sout_er_
souters74422602sout_ers
southed114313992southe_d
southerly1544182southerly
southron1145492southron
youthen1336152youthe_n
bother115218063bo_ther_
bothers124317753bo_thers
boxthorn2043693boxthorn
cithern12489913_cithern
cothurn1245053co_thurn
coucher144515853coucher_
couchers153513863couchers
cougher133711733cougher_
coughers14399963coughers
couter84930223cout_er_
couters93827303cout_ers
couthest13312083couthest
couthier13218913couthier_
druthers1275793druthers
goatherd1335263goatherd
goutier82612353goutier_
isothere1145793iso_there
isotherm1344283iso_therm
leathern11398913leathern
loather103711003loather_
loathers113310443loathers
lutherns1136293_lutherns
mother113718643mo_ther_
mothers123717623mo_thers
mothery153710513mo_thery
mouthed133811043mouthe_d
mouthier13208173mouthier_
norther1039733norther_
northerns1244933northerns
northers1139333northers
nother93815963no_ther_
other84219103_o_ther_
others93918003_o_thers
outburn936903_outburn
outearn7310683_outearn
outer55633303_out_er_
outers64230173_out_ers
outhear10910603_outhear
outheard1288543_outheard
outhears11810393_outhears
outlearn836433_outlearn
outseen72712333_outseen
outsert72819513_outsert
outturn737123_outturn
outworn101610753_outworn
postern93615613post_ern
potheen12257893po_theen
pother113818853po_ther_
potherb14358683po_therb
pothers123818623po_thers
pouter83923983pout_er_
pouters94221873pout_ers
poutier93215323poutier_
roughen11338833roughe_n
rougher113511033rougher_
roughers12329183roughers
router65025843rout_er_
routers74822873rout_ers
saltern74010653salt_ern
sauterne846253saut_erne
scouter93313323scout_er_
scouters103411323scout_ers
scouthered1643643scouthered
scouthering1743483scouthering
scutcheon1642273scutcheon
scutcher15176963scutcher_
scutchers16175643scutchers
scutter93512173scutter_
scutters103311023scutters
shorthorn1543993shorthorn
shouter103213083shout_er_
shouters113510623shout_ers
shusher13288113shusher_
shushers14267053shushers
shutter103712143shutter_
shutters113611353shutters
slather103816073slather_
slathers113914783slathers
slattern837093slattern
slither104112983slither_
slithers114212953slithers
slithery14356703slithery
sloucher13206813sloucher_
slouchers14185623slouchers
smithers13369793smithers
smithery16325703smithery
smoothen13204963smoothe_n
smoother13196673smoother_
smoothers14206043smoothers
smother123510213smother_
smothers13349933smothers
smothery16296063smothery
snoutier8206973snoutier_
soften9429493soft_e_n
softer94015313soft_er_
softhead1545003softhead
soothe94214853soothe__
soothed113712743soothe_d
soothes103917113soothe_s
soothest113312243soothest
sootier73916613sootier_
sorter64425093sort_er_
sorters74221133sort_ers
soughed123811623soughe_d
sounder83315383sounder_
sounders93214113sounders
soupier93111753soupier_
sourer63620213sou_rer_
south85223573south___
southeast1246793southeast
southing122811823southing
southland1363713southland
southpaw1641973southpaw
southrons1245843southrons
souths95216603south__s
southward1653933southward
southwest1545453southwest
spouter94213223spout_er_
spouters104011163spout_ers
sputter94014053sputter_
sputters104012873sputters
sputtery13366473sputtery
stern55319123s__t_ern
stouten7307333stout_e_n
stouter74012053stout_er_
stutter72911463stutter_
stutters83210473stutters
sutler63718393s_utler_
sutlers73116973s_utlers
swather134213603swather_
swathers144512083swathers
swither133710993swither_
swithers144310533swithers
tother94117143to_ther_
toucher124814353toucher_
touchers133611213touchers
toughen11329203toughe_n
tougher114210983tougher_
touter63821033tout_er_
touters74018353tout_ers
voucher154110263voucher_
vouchers16418623vouchers
wuther124511613_wuther_
wuthers133711523_wuthers
youthens1435383youthens
zithern19447023_zithern

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.1531167915.0
2DLD Change Limit1461621657.09620597.8
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.30924448.1
 
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.