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

197 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
oxtail133765(None) 
foxtail1745381foxtail
oxtails1436381oxtails
bobtail1146552bobtail
detail74516432detail
entail61114342entail
foxtails1844582foxtails
obtain839182obtain
octal71214722octa_l
outsail71411412outsail
retail65522072retail
tail45443652__tail
agnail739533agnail
ail37171043___ail
aortal65217513aorta_l
artal55525473arta_l
assail6610153assail
attain6311753attain
avail8313883_avail
axal116520493ax_a_l
axial124515193axia_l
axil116424453ax__il
bail65042803__bail
bewail1189583bewail
bobtails1245193bobtails
boxball18155323boxball
boxhaul1943013boxhaul
brail75525553_brail
camail10314833camail
cattail939183cattail
coattail1045313coattail
cocktail1645363cocktail
coital84117053coita_l
contain9315833contain
contrail10410983contrail
costal85419513costa_l
coxal146116673cox_a_l
curtail9299663curtail
derail74218813derail
details84214043details
detain74617383detain
dotal64919623dota_l
dovetail1244393dovetail
drail65020973_drail
email74715103_email
entails7912823entails
entoil6912493entoil
extant132714753extant
extol1247893ext_ol
extoll1334863extoll
fail74840243__fail
fantail10310233fantail
fatal84819373fata_l
fetal85623373feta_l
fetial95716193fetial
flail85316183_flail
foetal9311883foeta_l
fontal9313143fonta_l
frail85220213_frail
grail64622873_grail
hail74839063__hail
hobnail1243973hobnail
horntail11105033horntail
jail115529093__jail
jezail2234643jezail
kail85131493__kail
litai55216363litai_
mail65543453__mail
metal75427383meta_l
mocktail1643673mocktail
mortal84616853morta_l
nail45838653__nail
natal53921493nata_l
nitril62511533nitril
nostril749303nostril
notal55221353nota_l
obtains939163obtains
octad81510653octa_d
octadic1245713octadic
octads987333octads
octan71313483octa_n
octane81411633octane
octanol944743octanol
octans81411143octans
octant81216553octant
octaval1243583octaval
octave11157343octave
octavo11124783octavo
octyl10136063oct_yl
offal1136243offa_l
oil37452053o___il
ontic74418573ont_ic
oorali6311263oorali
ootid61416703oot_id
opal66923523o_pa_l
optic93715183opt_ic
oral47638123o_ra_l
orchil1158653orchil
ordain7810403ordain
osteal6312963osteal
ostia52315583ost_ia
otic66624823o_t_ic
ottar54313993otta_r
ottars64112223ottars
ottava963683ottava
outact8317203outact
outadd837803outadd
outage72017533outage
outask1039103outask
outate62923403outate
outbawl1237473outbawl
outbid91411863outbid
outcall9310123outcall
outcavil1343833outcavil
outdid81210923outdid
outfall1039683outfall
outfit93014953outfit
outgain81010743outgain
outhaul1039063outhaul
outhit92818473outhit
outkill1136553outkill
outlaid81110653outlaid
outlain71212613outlain
outlie62419533outlie
outrig72812853outrig
outsaid81210923outsaid
outsails8139863outsails
outsin63617563outsin
outsit63620893outsit
outvie92412803outvie
outwait10411763outwait
outwile10310263outwile
outwill1037323outwill
outwit93014593outwit
oval77119523o_va_l
oxalic1537093oxalic
oxalis1339223oxalis
oxcart1539523oxcart
oxid12815483ox__id
oxidic1635943oxidic
oxim131114053ox__im
oxlip1456883ox_lip
oxter123414093oxt_er
oxters134813273oxters
oxyacid2062773oxyacid
oxyphil2242373oxyphil
pail66141833__pail
petal76526893peta_l
pigtail1046623pigtail
pintail9311183pintail
pontil8315463pont_il
ponytail1344553ponytail
portal84218463porta_l
postal84317533posta_l
quail144314363_quail
rail46147763__rail
ratal55025113rata_l
rattail737803rattail
redtail858713redtail
remail85017123remail
renail65020763renail
resail64418733resail
retails74718973retails
retain64523283retain
retial64724993retial
sail45447163__sail
serail64222673serail
setal56430903seta_l
sextain14257103sextain
snail57020203_snail
spail74921553_spail
staid66722083_staid
staig65519643_staig
stain55727943_stain
stair54719943_stair
stall54722353_stall
swail86217163_swail
tael46030713__tael
tails55634193__tails
tain45548073__tain
tali46837163__tali
tall47240213__tall
tenail64516113tenail
til36350263__t_il
toenail738783toenail
toil46536283__toil
topsail976523topsail
total55321823tota_l
trail55126773_trail
unnail6410583unnail
until53517743unt_il
vail75432553__vail
ventail10310453ventail
vital84819673vita_l
voltaic1245453voltaic
wagtail1145043wagtail
wail75238823__wail

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161975.37620966.5
3Display Results1971970.0633127.0
 (SQL Overall)1786911975.82930655.5
 
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.