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

179 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
shoddier133420(None) 
shoddies1336041shoddies
cloddier1234062cloddier
hoodier113812972_hoodier
shadier113111152sh_adier
shedder12339322shedd_er
shoalier1137062shoalier
shodden12265752shodd_en
shoddiest1434752shoddiest
shoddily1643562shoddily
showier1339092sho_wier
shudder12297322shudd_er
skiddier1464192skiddier
soddies92312852s_oddies
soldier82812152s_oldier
stodgier1034222stodgier
bloodier1136823bloodier
broodier1157433broodier
chokier1638043cho_kier
choosier1337163choosier
choppier17286643choppier
chowder16387803chowd_er
chudder14245943chudd_er
cloudier1135053cloudier
codder104416333_codd_er
coddler113710823_coddler
cruddier1244153cruddier
dodder94712913_dodd_er
dodgier10388243_dodgier
dowdier12328573_dowdier
faddier1237783_faddier
fodder114712113_fodd_er
ghostier1235383ghostier
giddier10308723_giddier
godlier938893_godlier
goodlier1035793goodlier
grodier939673gro_dier
handier113817443_handier
hardier114721543_hardier
headier113212953_headier
hedgier12367873_hedgier
hoarier104211743_hoarier
hodden113811453_hodd_en
hoddin11369933_hoddi_n
hoddins12289373_hoddins
hokier134214033_ho_kier
holder104619653_hold_er
holier94921623_ho_lier
homier116416993_ho_mier
hoodie105116133_hoodie_
hoodies113419833_hoodies
hookier143811673_hookier
hootier104915343_hootier
hoppier143110703_hoppier
hornier103012453_hornier
horsier103013243_horsier
hosier94219613_ho_sier
howdie13349723_howdie_
howdied15296843_howdied
howdies142911953_howdies
huddler12379423_huddler
moldier103110033_moldier
moodier103212203_moodier
muddier114110013_muddier
nodder84811943_nodd_er
noddies93512043_noddies
odder74515393__odd_er
phonier122710633pho_nier
plodder1146003plodd_er
podgier11338723_podgier
prodder1147953prodd_er
rowdier11348593_rowdier
ruddier9338523_ruddier
sadder82916973s_add_er
saddler93811963s_addler
sandier84017843s_andier
scolder103210333scold_er
scowder13286853scowd_er
sedgier9399043s_edgier
seedier83513633s_eedier
shabbier1535183shabbier
shader104218763sh_ad_er
shadower1544863shadower
shadowier1642893shadowier
shaggier13116053shaggier
shakier143411153sh_akier
shalier103116423sh_alier
shandies122714103shandies
shedded13419063shedd_ed
shedders13267433shedd_ers
shedding14278113shedding
sheenier11167423sheenier
shellier1138393shellier
shelvier1464913shelvier
shier85428943sh___ier
shiftier1436333shiftier
shindies122610503shindies
shinier104113143sh_inier
shirtier1137933shirtier
shittier1137303shittier
shlockier1842573shlockier
shoaler102610073sho_aler
shocker163411423sho_cker
shoddiness1543563shoddiness
shoddy1434533shodd__y
shoer84722153sho___er
shooter103013973sho_oter
shopper143312623sho_pper
shorter103515493sho_rter
shortie10411323shortie_
shorties11414573shorties
shoulder1234753shoulder
shouter103213073sho_uter
shoveler14165583shoveler
shover124515983sho__ver
shower124315103sho__wer
showerer1436163showerer
shredder1334393shredder
shudders13316643shudd_ers
shuddery16263413shudd_ery
skidder1365733skidd_er
sledder9399203sledd_er
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
sludgier1034823sludgier
smoggier1243973smoggier
smokier1356703smo_kier
smolder10327753smold_er
smudgier1233753smudgier
snobbier1234633snobbier
snoopier10177273snoopier
snootier8278373snootier
snoozier17185183snoozier
snottier8217373snottier
snoutier8206973snoutier
snowier1038783sno_wier
soapier93411713s_oapier
sodded94113303s_odd_ed
sodden84011513s_odd_en
sodding103712733s_odding
soggier93410883s_oggier
solder73921343s_old_er
soldiers9277773s_oldiers
soldiery12254613s_oldiery
solider82912453s_olider
sonder73623523s_ond_er
sonsier7711743s_onsier
sootier73916603s_ootier
soppier112711583s_oppier
sorrier72313723s_orrier
soupier93111753s_oupier
speedier1146623speedier
spendier1147143spendier
spongier1135733spongier
spookier14175493spookier
spoonier10167653spoonier
sportier102010053sportier
spottier10207303spottier
spudder11256553spudd_er
steadier937313steadier
stockier14217253stockier
stolider936603stolider
stonier72013793sto_nier
stormier1036103stormier
studdie9195273studdie_
studdies10207073studdies
studier82510053s_tudier
studlier935473studlier
sturdier9216953sturdier
sudsier868773s_udsier
swoonier11185133swoonier
swoopier13175143swoopier
thornier1135323thornier
toddies93011993_toddies
toddler9379043_toddler
woodier113912063_woodier
woodsier1245473woodsier
wordier112511203_wordier

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.1731032896.0
2DLD Change Limit1461621797.29620033.2
3Display Results1791790.0632841.3
 (SQL Overall)1786911797.53223724.2
 
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.