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

153 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
odea5622457(None) 
idea59122771idea
oda48133041od_a
ode47446581ode_
odes57243241odes
olea46532721olea
area45843392area
asea46327182asea
bode75838752bode_
boded95124962boded
bodega1034932bodega
bodes84935102bodes
bohea105013732bohea
coda77029342cod_a
code77347732code_
codec107120342codec
coded95433182coded
codeia94112192codeia
coden86128542coden
coder86134222coder
codes86247292codes
codex155817582codex
de37049542_de_
dead65434242_dead
deaf85838402_deaf
deal56347412_deal
dean56039482_dean
dear55343602_dear
deb66342692_deb
dee47665822_dee
def76546722_def
del46752752_del
den47554342_den
dev76033772_dev
deva85720982_deva
dew77139922_dew
dex116936882_dex
dey77243372_dey
doe47361952doe_
doer57734702doer
does56554472does
dona55529632dona
dopa77220902dopa
edema8610552edema
elodea738672elodea
flea75628492flea
fovea11310482fovea
godet7530042godet
ideal65716392ideal
ideas65919012ideas
idem76121062idem
ides57734232ides
ilea45931462ilea
kea76540912_kea
lea37660182_lea
lode56240112lode_
loden66621142loden
lodes66436912lodes
mode75840302mode_
model84521692model
modem103717142modem
modes85537412modes
node513036882node_
nodes64633492nodes
oba57531552o_ba
obe56638642obe_
obeah1038992obeah
obes66036832obes
obey96521302obey
obia67923112obia
oca56731732o_ca
ocean71212962ocean
ocrea73311822ocrea
od39255242od__
odah87018932odah
odas57230262odas
odd57725452od_d
odder74515392odder
odds68919922odds
odeon6411482odeon
odeum84610542odeum
odic74920572odic
odor55718092odor
ods47546212od_s
odyl84111462odyl
oe28473062o_e_
oedema936572oedema
oes35866192o_es
ogee57629882ogee
ohed87825182ohed
ohia75719362ohia
oidia6314952oidia
oka76926802o_ka
oke75839482oke_
okeh114615322okeh
okes84936342okes
okra86413572okra
olden65114852olden
older65121172older
ole37155212ole_
oleo46630482oleo
oles46453472oles
olla44821172olla
omega836382omega
omen66828182omen
omer67028392omer
one37050912one_
ones46146532ones
ope56845242ope_
oped76230152oped
open66427002open
opera7313572opera
opes65942612opes
ora37250832o_ra
orca65522772orca
ordeal779252ordeal
order65019362order
ore36661832ore_
oread64619602oread
ores46056682ores
orra46120722orra
ose38147342ose_
oses46641512oses
ossa43714162ossa
ova66823792o_va
oven76624142oven
over77227342over
owe67041032owe_
owed86833872owed
owes75137102owes
oxen116218592oxen
oxes116530722oxes
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
pea56657242_pea
plea66830602plea
podia8415282podia
rhea75017432rhea
rode55844302rode_
rodeo65921092rodeo
rodes614039082rodes
sea36161292_sea
shea76031572shea
soda56329382sod_a
tea37353322_tea
toea46732332toea
urea46528062urea
uvea74712652uvea
vodka1354342vodka
yea66445752_yea
yodel94714082yodel
zoea137118422zoea

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.283631417.0
2DLD Change Limit298721530.93631914.5
3Display Results1531530.0305100.0
 (SQL Overall)1786911531.249143067.3
 
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.