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

205 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
oxy13632098(None) 
boxy166420731boxy
doxy156419951doxy
foxy176517751foxy
ox98242381ox_
oxo107322961oxo
oy58950131o_y
poxy166820891poxy
aby810238062aby
any68440482any
ax911057782ax_
axe108239492axe
ay511773892_ay
bay89661642bay
bey86645422bey
body107425672body
bogy106426192bogy
bony96732082bony
box1210142342box_
boy87753562boy
buy86436542buy
by77529232_by
cay87155982cay
coky137526822coky
coly96940532coly
cony96537832cony
copy116229802copy
cory96941512cory
cosy97232702cosy
cowy126427362cowy
cox1210346782cox_
coxa136922962coxa
coy810557552coy
cozy185823802cozy
cry89726242cry
day76254112day
deoxy1648882deoxy
dexy156118552dexy
dey77243372dey
doby106022162doby
dogy96126492dogy
dopy106224152dopy
dory85836232dory
doty86128222doty
dozy175920322dozy
dry76526032dry
epoxy17465772epoxy
ex98835642ex_
fay97454862fay
fey95940882fey
fly97124952fly
fogy115923182fogy
fox136737862fox_
foy96044262foy
fozy197017162fozy
fry96226502fry
gay76856492gay
gey75738302gey
goby106021082goby
gory86129662gory
gox117137182gox_
goy77844552goy
guy75728942guy
hay97358772hay
hey96741062hey
holy106333432holy
homy126623222homy
hoy97447912hoy
icy86322122icy
ivy96317442ivy
jay136242672jay
joey145719332joey
joky186215312joky
joy137036362joy
kay106745542kay
key105833332key
lay68865352lay
ley66246812ley
logy87025782logy
lory75931712lory
lox108240962lox_
may88757622may
moly96031912moly
mony96830002mony
mopy115721972mopy
moxa136917742moxa
my78125652_my
nay66952772nay
nixy145714512nixy
nosy76322892nosy
oaf65952882oaf
oak76238652oak
oaky116419952oaky
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obey96521302obey
obi57127722obi
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
ods47546212ods
odyl84111462odyl
oe28473062o_e
oes35866192oes
of58247772o_f
ofay106416102ofay
off96331632off
oft67744062oft
oh57447002o_h
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oil37452052oil
oily77932252oily
oka76926802oka
okay115917662okay
oke75839482oke
old47033462old
oldy85316842oldy
ole37155212ole
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
only75319722only
ono36838032ono
ons36148512ons
onyx1478362onyx
ooh67637092ooh
oot311274692oot
oozy167018132oozy
op45850162o_p
ope56845242ope
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orb55736862orb
orby97519602orby
orc57034922orc
ore36661832ore
orgy85218002orgy
ors35750112ors
ort39465232ort
oryx14510212oryx
os211359882o_s
ose38147342ose
oud47439072oud
our36042892our
out38072152out
ova66823792ova
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
oxen116218592oxen
oxes116530722oxes
oxeye1536912oxeye
oxid12815482oxid
oxim131114042oxim
pay88461182pay
pixy166117762pixy
ply86323552ply
pogy105623552pogy
poky135922152poky
poly96235152poly
pony96434052pony
posy96028422posy
pox126140692pox_
proxy175011012proxy
pry85728052pry
pyx157817012pyx
ray66361992ray
ropy96323412ropy
rosy76024872rosy
say67264762say
sexy146418022sexy
shy96728192shy
sky106420992sky
sly66228562sly
sox106444192sox_
soy67851452soy
spy86023742spy
sty66227312sty
thy97022912thy
toby96322292toby
tody86327212tody
tony75635152tony
tory75840542tory
towy105325472towy
toy69655192toy
try66529672try
vox136628152vox_
waxy175918202waxy
way96757662way
why126920012why
wry96524702wry
xi98128162_xi
xu96018832_xu
yay96948712yay

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.0632836365.1
2DLD Change Limit140842050.40634689.7
3Display Results2052050.0464456.5
 (SQL Overall)1786912050.515346972.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.