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

252 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
dodgems1257644(None) 
dodgem116710041dodgem_
dodgers105213821dodgers
dodges96119081dodge_s
codgers115113932codgers
dodders105511792dodders
dodge86618132dodge__
dodged107514692dodge_d
dodger95817052dodge_r
dodgery13627782dodgery
dodoes85716102dodoe_s
dogdoms1295422dogdoms
doges75630162do_ge_s
dogeys115510662do_geys
doggers104413432doggers
lodgers95113832lodgers
lodges86820152lodge_s
modems114610762mod_ems
wodges117413682wodge_s
adeems946333_adeems
badgers114812653badgers
badges103917373badge_s
bodegas1135483bodegas
bodes84935103bod_e_s
bodies94524143bodie_s
bogeys124510913bo_geys
boogers104514633boogers
boogeys13476873boogeys
budgers114314923budgers
budges104820133budge_s
budgets11489863budgets
cadgers114712003cadgers
cadges104716713cadge_s
codders114114453codders
codecs115112933cod_ecs
codens94821013cod_ens
coders95426983cod_ers
codes86247293cod_e_s
codger105814873codge_r
congees103517923congees
congers104223233congers
conges94928173conge_s
cudgels1135333cudgels
dadgum1134583dadgum_
dadoes85616533dadoe_s
daggers103714913daggers
dangers94818213dangers
deems85421773__deems
degerms1135623d_egerms
degums10438623d_egums
diadems1135393diadems
didies84621833didie_s
didoes85716963didoe_s
diggers104413393diggers
dingers94321383dingers
dinges83825423dinge_s
dingeys12458403dingeys
diodes83915783diod_e_s
dirges84915103dirge_s
dobbers123513253dobbers
dobies94422093dobie_s
dockers143715003dockers
dockets144412243dockets
dodder94712913dodde_r
doddery13516853doddery
dodgeries1246593dodgeries
dodgier10388243dodgier
dodgiest11308713dodgiest
dodginess1235283dodginess
dodging11299063dodging
dodgy116611463dodg__y
dodoism1135893dodoism
dodoisms1244523dodoisms
dodos75819393dod__os
doers65225713do__ers
does56554473do__e_s
doffers14359853doffers
dogdom1186363dogdom_
doge66233803do_ge__
dogear838193do_gear
dogears937513do_gears
dogedoms1344333do_gedoms
dogey105719513do_ge_y
dogged106017703dogge_d
dogger95216783dogge_r
doggery13448263doggery
doggies103613023doggies
doggrels1142633doggrels
dogies85022253do_gies
doglegs1034783doglegs
dogma96112463do_g_ma
dogmas105011243do_gmas
dogs66440153do_g__s
doldrums1243053doldrums
doles67843753do_le_s
dolmens10388693dolmens
domes85735563do_me_s
doms76239573do___ms
donees74519493do_nees
dongas84914613dong_as
dongles93212873dongles
dongs76525813dong__s
donkeys15426663donkeys
donnees84210363donnees
donzels1735393donzels
doodies94218773doodie_s
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613doolees
dooms85321343do__oms
doozers17419293doozers
dopers95522483do_pers
dopes84935043do_pe_s
dories75232363dorie_s
dormers104313923dormers
dorms85723843do__rms
dorpers104113173dorpers
dorsels84412573dorsels
dorsers83516303dorsers
dosages92310803dosage_s
dosers75723633do_sers
doses65938503do_se_s
dossels85511603dossels
dossers84516233dossers
dosses76126273dosse_s
dotages92311793dotage_s
doters74423913do_ters
dotes65836693do_te_s
dottels8327783dottels
dotters83715973dotters
doughs115912933doug_hs
doums85417643do__ums
dousers84817273dousers
douses74928933douse_s
dovens104413903do_vens
doves94728153do_ve_s
dowagers1334893dowagers
dowdies123412733dowdie_s
dowels104813343do_wels
dowers104523293do_wers
downers113912773downers
dowsers115013533dowsers
dowses105718303dowse_s
doxies143917853doxie_s
doyens104810223do_yens
doyleys14384923doyleys
dozens164612463do_zens
dozers164815423do_zers
dozes155226303do_ze_s
dragees9359483dragees
dredgers11256093dredgers
dredges10379353dredge_s
drudgers11326853drudgers
drudges10308873drudge_s
dudeens934863dudeens
dudes75424373dud_e_s
dudgeon10134143dudgeon
dudgeons11163943dudgeons
edgers84413923_edgers
edges75718743_edge_s
fadges114814033fadge_s
fidges114114393fidge_s
fidgets12388763fidgets
fodders124010753fodders
fodgel1136413fodge_l
fogeys13509263fo_geys
foggers124112013foggers
forgers115218183forgers
forges105024263forge_s
forgets113813793forgets
fudges114314503fudge_s
gadgets10348683gadgets
gems75329113___gems
goddams1233983goddams
goddess1035263goddess
godets8410933god_ets
godless938403godless
golems939323go_lems
gorgers94813643gorgers
gorges85321893gorge_s
gorgets94711783gorgets
gougers94911763gougers
gouges86318693gouge_s
hedgers124310263hedgers
hedges115016263hedge_s
hoddens12378803hoddens
hoggers124512483hoggers
hoggets12498323hoggets
iodisms10308483iodisms
joggers164110693joggers
judgers16369043judgers
judges153713463judge_s
kedges124812983kedge_s
ledgers94912183ledgers
ledges84918013ledge_s
lodens74315063lod_ens
lodes66436913lod_e_s
lodge76520093lodge__
lodged913815713lodge_d
lodger86517693lodge_r
loges66534203lo_ge_s
loggers94616133loggers
loggets9378913loggets
longers84819543longers
longes75925573longe_s
midges103516483midge_s
midgets113910253midgets
models94216353mod_els
modem103717143mod_em_
modes85537413mod_e_s
mongers104217273mongers
morgens10310463morgens
nidgets9358143nidgets
nodders94410263nodders
nodes64633493nod_e_s
noodges9317713noodge_s
nudgers9479373nudgers
nudges84114743nudge_s
oddness935313oddness
odes57243243_od_e_s
odeums9367313_odeums
odiums9337943_odiums
ogams84112683_o_gams
ogees65119143_o_gees
oodles73517183oodle_s
podiums12227633podiums
poems95715553po__ems
pogeys124110353po_geys
pongees104212543pongees
redeems1037163redeems
ridgels9348023ridgels
ridges85817013ridge_s
rodeos75314503rod_eos
rodes614039083rod_e_s
rodless8310073rodless
rogers74517913ro_gers
rouges76022383rouge_s
sedges83817813sedge_s
soddens9348413soddens
sodiums10177213sodiums
sodoms989673sod_oms
stodges9309083stodge_s
todies74223553todie_s
tongers84116013tongers
totems86810763to_tems
wedges114614583wedge_s
widgets12318453widgets
wodge107212933wodge__
yodels104610073yod_els
yodlers11298923yodlers
yodles103714333yodle_s
yogees10510633yo_gees

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.406440125.6
2DLD Change Limit1340272525.68623571.4
3Display Results2522520.0803150.0
 (SQL Overall)1786912526.17228951.9
 
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.