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

172 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
oxo10732296(None) 
oho66534381oho
ono36838031ono
ox98242381ox_
oxy136320981oxy
abo59045962abo
ado49146872ado
ago48845522ago
apo511142122apo
avo68936232avo
ax911057782ax_
axe108239492axe
axon115524302axon
azo128233392azo
bio57846082bio
bo410957572_bo
boho96923322boho
bolo65535952bolo
boo58163662boo
box1210142342box_
boxy166420732boxy
boyo96923842boyo
bozo156821412bozo
bro56236602bro
coco87330602coco
coho97524492coho
coo59566362coo
cox1210346782cox_
coxa136922962coxa
do310155252_do
dodo66024912dodo
dojo126016142dojo
doxy156419952doxy
duo48536142duo
ego46726052ego
ex98835642ex_
exon117116802exon
expo1349182expo
fox136737862fox_
foxy176517752foxy
fro65530642fro
go38748742_go
gobo76126902gobo
gogo69722832gogo
goo47754772goo
gox117137182gox_
hao67251122hao
ho510258272_ho
hobo97026082hobo
homo96126472homo
jo99539602_jo
kobo107422102kobo
kolo87026222kolo
koto86323472koto
lo28053442_lo
lobo67229862lobo
loco67030742loco
logo57931762logo
loo38359822loo
lox108240962lox_
mho86624622mho
mo49158482_mo
mojo136917222mojo
mono66036722mono
moo58460512moo
moxa136917742moxa
mozo157719742mozo
no29353242_no
nolo46229312nolo
noo37154042noo
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oboe66822942oboe
obol65220612obol
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
odor55718092odor
ods47546212ods
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
oh57447002o_h
ohm86523012ohm
ohs66232312ohs
oi29061482o_i
oil37452052oil
oka76926802oka
oke75839482oke
old47033462old
ole37155212ole
oleo46630482oleo
olio46829672olio
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
onos46229002onos
ons36148512ons
onto46127662onto
ooh67637092ooh
oot311274692oot
op45850162o_p
ope56845242ope
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orb55736862orb
orc57034922orc
ordo54622352ordo
ore36661832ore
ors35750112ors
ort39465232ort
orzo134516782orzo
os211359882o_s
ose38147342ose
otto45220642otto
oud47439072oud
our36042892our
out38072152out
ouzo133516932ouzo
ova66823792ova
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
oxbow1734442oxbow
oxen116218592oxen
oxes116530722oxes
oxid12815482oxid
oxim131114052oxim
oy58950132o_y
poco86826152poco
polo66236632polo
pomo85828452pomo
poo57757112poo
pox126140692pox_
poxy166820892poxy
pro55837262pro
rho65924832rho
roto45935052roto
so28855442_so
solo45538942solo
sox106444192sox_
tao38358952tao
tho67433962tho
to218858982_to
too38965422too
topo66932402topo
toro48045682toro
toyo76925452toyo
two67925832two
udo49027302udo
upo58925862upo
vox136628152vox_
who95526772who
wo510447762_wo
woo66949802woo
xi98128162_xi
xu96018832_xu
yo59748552_yo
zoo126238912zoo

Search took 1 second 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 Filter178691140840.296603685.8
2DLD Change Limit140841720.43632302.8
3Display Results1721720.0305733.3
 (SQL Overall)1786911720.762234502.6
 
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.