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

147 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
shoulder123475(None) 
shoulders1334221shoulders
smoulder1133441smoulder
boulder103411342_boulder
holder104619652_ho_lder
hounder113412232_hounder
moulder10389802_moulder
scolder103210332sco_lder
shielder1235182shielder
shoaler102610072shoal_er
shoalier1137062shoalier
should1038022should__
shouldered1542232shouldered
shouldest1344142shouldest
shouldst1243392shouldst
shouter103213072shou_ter
shudder12297322sh_udder
smolder10327752smo_lder
smoulders1243132smoulders
solder73921342s_o_lder
sounder83315382s_ounder
aulder7511453__aulder
beholder1435053beho_lder
bolder94820933_bo_lder
boulders113010023_boulders
bouldery14295013_bouldery
bounder104215533_bounder
bowlder13407473_bowlder
choler113717153cho_l_er
chouser125212943chou_ser
chowder16387803cho_wder
chudder14245943ch_udder
coholder1436063coholder
colder95121833_co_lder
coulter94115593_coulter
flounder1235103flounder
folder104317543_fo_lder
fouler93614903_foul_er
founder114312563_founder
gasholder1443823gasho_lder
ghoulie1144253ghoulie_
ghoulies1235393ghoulies
golder84417603_go_lder
grounder1047603grounder
hauler95015123_haul_er
haulier1059943_haulier
hoarder11329233_hoarder
holden104113953_ho_lden
holders113715903_ho_lders
holier94921623_ho_lier
holler93520613_ho_ller
hounded123311033_hounded
hounders123111703_hounders
houser95322283_hou_ser
howler123514313_howl_er
huller93919103_h_uller
inholder1276113inho_lder
louder74414603_lou_der
molder93819273_mo_lder
moulded11348063_moulded
moulders11348333_moulders
mouldier1154953_mouldier
moulter93812423_moulter
older65121173__o_lder
polder94019253_po_lder
poulter93712013_poulter
pounder103313993_pounder
prouder10310373prou_der
rounder83514593_rounder
scolded11358853sco_lded
scolders11288993sco_lders
scourer93910433scou_rer
scourger1134723scourger
scouter93313323scou_ter
scouther1356943scouther
scowder13286853sco_wder
scowler12248173scowl_er
sculker13318323s_culker
sculler99812153s_culler
shader104218763sh__ader
shalier103116423sh_alier
shauled1148793shaul_ed
shedder12339323sh_edder
sheller103515883sh_eller
shellier1138393shellier
shelter103214953sh_elter
shelver134211063sh_elver
shielded1334393shielded
shielders1334753shielders
shoaled113810963shoal_ed
shocker163411423sho_cker
shodden12265753sho_dden
shoddier1334203shoddier
shoer84722153sho___er
shooled115212653shool_ed
shooter103013973sho_oter
shopper143312623sho_pper
shorter103515493sho_rter
shouldering1662343shouldering
shouted113911543shou_ted
shouters113510593shou_ters
shoveler14165583shoveler
shoveller15174543shoveller
shover124515983sho__ver
shower124315103sho__wer
showerer1436163showerer
showier1339093sho_wier
shredder1334393shredder
shrewder1534393shrewder
shriller1136823shriller
shrouded1333593shrou_ded
shucker163710103sh_ucker
shudders13316643sh_udders
shuddery16263413sh_uddery
shunner10358643sh_unner
shunter103611723sh_unter
shusher13288113sh_usher
shutter103712133sh_utter
skulker10325683s_kulker
sloucher13206813sloucher
smolders11287193smo_lders
smouldered1441963smouldered
snoutier8206973snoutier
solders83517773s_o_lders
soldier82812153s_o_ldier
solider82912453s_olider
solver94016703s_o_lver
sonder73623523s_o_nder
souled75419823s_oul_ed
sounded93214463s_ounded
sounders93214103s_ounders
soupier93111753s_oupier
sourer63620213s_ou_rer
souter64225923s_ou_ter
souther104116303s_outher
spoiler93310683spoil_er
spooler93711383spool_er
spouter94213223spou_ter
spudder11256553s_pudder
stolider936603stolider
stounded10276213stounded
stouter74012053stou_ter
sulker104015923s__ulker
sunder74019823s__under
swounded13314563swounded
thunder1136963th_under
upholder1444083upho_lder

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.1561145455.1
2DLD Change Limit1461621478.06318127.5
3Display Results1471470.0632333.3
 (SQL Overall)1786911478.28221575.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.