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 “rode” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

389 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
rode5584430(None) 
bode75838751bode
code77347731code
erode64520991erode
lode56240111lode
mode75840301mode
node513036881node
ode47446581_ode
rede55037671rede
ride55945131ride
robe65335641robe
rod47953891rod_
rodeo65921091rodeo
rodes614039081rodes
rods56442061rods
roe36861081ro_e
role45851821role
rope65542911rope
rose46148901rose
rote46249021rote
roue45941741roue
rove75136981rove
rude55632781rude
trode65322851trode
abode85518812abode
aide56045002aide
anode65021042anode
arose55832082arose
bade75140882bade
bide76041502bide
bod67055542bod_
boded95124962boded
bodes84935102bodes
bods76244712bods
body107425672body
bole66448692bole
bone65949322bone
bore66051332bore
brede85520502brede
bride86425532bride
broke116019782broke
brome94421972brome
brose75227032brose
cade76443912cade
cede74928772cede
cod69660122cod_
coda77029342coda
codec107120342codec
coded95433182coded
coden86128542coden
coder86134222coder
codes86247292codes
codex155817582codex
cods76848102cods
coed77140542coed
coke107038382coke
cole66956112cole
come87547702come
cone67256962cone
cope86847382cope
core67263112core
cote66648732cote
coude85022632coude
cove95837072cove
crone75231332crone
crore74922872crore
croze164719452croze
crude86018572crude
de37049542__de
diode74716112diode
dodge86618132dodge
dodo66024912dodo
doe47361952do_e
doge66233802doge
dole56550002dole
dome77240732dome
done55747912done
dope76038892dope
dore56353302dore
dose56442432dose
dote55442882dote
dove85131562dove
doze145829082doze
drone65324982drone
drove95518062drove
dude65629662dude
eide55832242eide
epode85114092epode
eroded84313582eroded
erodes74819882erodes
erose55727272erose
fade85736342fade
foe66350812fo_e
fore78351472fore
froe75329992fro_e
frore86218802frore
froze174515652froze
geode7412592geode
god57449792god_
godet7530042godet
gods65438042gods
gone55639042gone
gore55744962gore
grade75126092grade
gride75223582gride
grody103412062grody
grope84821612grope
grove95219332grove
gude65423332gude
hade85440192hade
hide85134642hide
hod76852462hod_
hods87239862hods
hoe67562722ho_e
hoed87837982hoed
hoke115935932hoke
hole77553392hole
home98042442home
hone77549322hone
hope96639672hope
horde94623052horde
hose76547242hose
hove107132222hove
howe106734102howe
irade65618152irade
irone55126362irone
jade125325442jade
joe106642352jo_e
joke155926162joke
jole117233822jole
kore85834162kore
krone94018732krone
lade56345982lade
lobe65535362lobe
loden66621142loden
lodes66436912lodes
lodge76520092lodge
loge56837192loge
lone45849132lone
lope65941922lope
lore45850352lore
lose45144582lose
love75234762love
lowe75435312lowe
lude55331642lude
made75440242made
mod69054402mod_
model84521692model
modem103717142modem
modes85537412modes
modi76826312modi
mods77945052mods
moke106234222moke
mole66251832mole
mome85239352mome
monde85723142monde
mope86838042mope
more67154522more
mote67048082mote
moue65835572moue
move96630722move
nide55535792nide
nod47549562nod_
nodes64633492nodes
nodi56626742nodi
nods55838222nods
nome66038422nome
none45743172none
nope65934192nope
nose46739362nose
note46239962note
nude56626272nude
obe56638642_obe
od39255242_od_
oda48133042_oda
odd57725452_odd
odea56224572_odea
odes57243242_odes
ods47546212_ods
oe28473062_o_e
oke75839482_oke
ole37155212_ole
one37050912_one
ooze136420602ooze
ope56845242_ope
order65019362order
ordo54622352ordo
ore36661832_ore
orle45630462orle
oroide7311702oroide
ose38147342_ose
owe67041032_owe
pod66351482pod_
pods76540152pods
poke105335362poke
pole65951302pole
pome85636692pome
pone65747532pone
pope85535612pope
pore66451262pore
pose66441732pose
pride84724732pride
probe94320812probe
prod76129502prod_
prods85523552prods
prole74527792prole
prone75332622prone
prose75835122prose
prove104823192prove
prude84615972prude
race66746262race
rad47662002rad_
rads56046602rads
rage55742352rage
rake84841572rake
rale45050562rale
rape65041632rape
rare45348432rare
rase46149982rase
rate45458762rate
rave75542092rave
raze135235432raze
re26153742r__e
recode93618712recode
red46755802red_
redd66323172redd
reded74829122reded
redes65139132redes
redo56029362redo
reds56042862reds
redye94413472redye
ree37974072r_ee
reed55549622reed
rete44944132rete
rice64942912rice
rid46754632rid_
rider65231302rider
rides66140812rides
ridge75018672ridge
rids56539552rids
rife74632322rife
rile45650532rile
rime65138882rime
ripe66038922ripe
rise45945232rise
rite45849452rite
rive75537722rive
road56332112road
roadeo7510322roadeo
roadie72813812roadie
roads66523622roads
roam67132412roam
roan47234202roan
roar46328572roar
rob56754302ro_b
robed85323732robed
robes75133302robes
roble75223022roble
robs65837872robs
roc520243252ro_c
rock105735182rock
rocs65533662rocs
rodded93713702rodded
rodent7519242rodent
rodeos75314502rodeos
rodmen939712rodmen
roes45954142roes
roger64521412roger
rogue66417532rogue
roil46235292roil
roles56747982roles
rolf75134872rolf
roll46331652roll
rom59855632ro_m
romeo73719702romeo
romp85926572romp
roms67038962roms
rondel73212642rondel
rondo65218372rondo
rood56733002rood
roods65125282roods
roof75738832roof
rook85532032rook
room66235082room
roose56127092roose
root45655922root
roped84630802roped
roper75431912roper
ropes75940062ropes
ropey106021872ropey
ropy96323412ropy
roque144812132roque
rosed65930342rosed
roses56445772roses
roset55945242roset
rosy76024872rosy
rot37282952ro_t
rota45834342rota
rotes56143902rotes
roti46332932roti
rotl45029682rotl
roto45935052roto
rots46454092rots
rotte54625932rotte
rouen54920902rouen
roues56039352roues
rouge65423442rouge
roup66627692roup
rouse56634702rouse
rout46153282rout
route55132072route
roux117419362roux
roved95323552roved
roven85521972roven
rover85527372rover
roves84834482roves
row67453672ro_w
rowdy125711532rowdy
rowed94034322rowed
rowel84721412rowel
rowen84921152rowen
rower85430492rower
rows75941752rows
rube65532012rube
rudd65917472rudd
ruder65320542ruder
rue35549262r_ue
rued55729792rued
rule49938422rule
rune45236302rune
ruse45938932ruse
rye66032542r_ye
ryke115616402ryke
sade55544472sade
sarode75317512sarode
side55444492side
sod46053702sod_
soda56329382soda
sods54940212sods
soke85436262soke
sole46053672sole
some66040382some
sonde64622832sonde
sone46649982sone
sore47059532sore
spode84617702spode
strode75215972strode
tide55237382tide
tod49457072tod_
tods56141842tods
tody86327212tody
toe310166852to_e
toed56137042toed
toke86738492toke
tole46052902tole
tome67543192tome
tone46953742tone
tope65946382tope
tore47359322tore
tote46643672tote
trade65026042trade
triode75311892triode
trod57627952trod_
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
unde55825482unde
vide85432762vide
voe67739052vo_e
vole75236982vole
vote74728622vote
wade85237062wade
wide85235412wide
wodge107212932wodge
woe66651242wo_e
woke115527962woke
wore77144672wore
wove105624312wove
wrote84717482wrote
yod77545502yod_
yodel94714082yodel
yodh119916102yodh
yodle94515042yodle
yods86531182yods
yoke115626392yoke
yore76335942yore
yowe106728742yowe
zone135231082zone

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298723890.78338150.7
3Display Results3893890.0934182.8
 (SQL Overall)1786913891.156154577.0
 
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.