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

134 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
dugongs105325(None) 
dugong934371dugong_
dongs76525812d__ongs
dugouts935042dugouts
dungs75821972du__ngs
gongs74921612__gongs
legongs934542legongs
agings86312673_agings
agones75719863_agones
agons66423783_agon_s
argons75018203argon_s
audings9289393audings
augends935883augends
barongs105310833barongs
belongs10408223belongs
bongs87828423__bongs
bugouts1036193bugouts
bungs85323863bu__ngs
busings103711223busings
bygones1335913bygones
cogons96818113cogon_s
dagobas1145143dagobas
dagoes85714603dago_es
dagos76419443dago__s
dangs75623203d__angs
darings93713653darings
debones103315113debones
defangs1235363defangs
defogs1156683defo_gs
demons94917723demon_s
depones103717093depones
devons104512253devon_s
diggings12316623diggings
dingdongs1341903dingdongs
dings76331403d__ings
diurons838823diuron_s
doggones1135713doggones
doglegs1034783doglegs
dogs66440153d__o_gs
doings84913183d_oings
donas65926473d__onas
dong66031653d__ong_
donga76718423d__onga
dongas84914613d__ongas
dons56048703d__on_s
dopings11408783dopings
dragons938383dragon_s
drones75023433d_rones
drongo836793d_rongo
drongos935493d_rongos
dubbings14245473dubbings
ductings12346673ductings
dudgeons11163943dudgeon_s
duding93913323duding_
duennas834143duennas
dugout8310363dugo_ut
dugs614832283du___gs
duking124715133duking_
dumpings14295763dumpings
dunes65332173du__nes
dung66328433du__ng_
dungeons10124623dungeon_s
dunging103012623dunging_
dungy104713643du__ngy
dunks105621193du__nks
duns55140433du__n_s
dunts65828413du__nts
duologs935363duologs
duomos936823du_omos
duos56728133du_o__s
duotones937643duotones
duping104113633duping_
during84419403during_
durions839963durion_s
durns64819873du_rn_s
durocs9569703duro_cs
duros65422693duro__s
dustings10419033dustings
dyeings12374643dyeings
dyings11478133d_yings
edgings10256243edgings
eggnogs1041923eggnogs
flongs105010493_flongs
furlongs12304073furlongs
futons93911513futon_s
gangs76222573__gangs
goings84911523__goings
gong66827193__gong_
hongs95126203__hongs
jupons15377803jupon_s
kalongs1255443kalongs
klongs11436603_klongs
legong836963legong_
logons79818173logon_s
longs65527063__longs
luging83915293luging_
lungs65223883lu__ngs
lutings83311053lutings
muggings13244593muggings
muggs94912323mug__gs
muons75816173mu_on_s
musings10389543musings
mutons84314363muton_s
oblongs1033533oblongs
oolongs845953oolongs
orgones81010793orgones
ourangs8318503ourangs
outgoings1143953outgoings
outings84014753outings
pagings114411063pagings
pongs85526343__pongs
prongs94314483_prongs
pulings103511323pulings
pungs85422223pu__ngs
purgings12347293purgings
putons83515153puton_s
rugolas836373rugolas
rugosas844973rugosas
rugous739653rugo_us
rulings83310383rulings
rungs611819403ru__ngs
sarongs84511803sarongs
songs67725553__songs
thongs104611193_thongs
throngs11508163throngs
tigons74112263tigon_s
tongs65928463__tongs
tubings10336483tubings
tungs65520623tu__ngs
udons65411463_udon_s
vuggs10579133vug__gs
wagons103911213wagon_s
wrongs10338933_wrongs
yupons11398353yupon_s

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271345.90622693.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911346.34228175.8
 
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.