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

191 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
desoxy174462(None) 
deoxy1648881de_oxy
decoy115716312deco_y
descry1256182descry
desex13311982desex_
desorb95210202desorb
detox13310952detox_
dexy156118552de__xy
doxy156419952d__oxy
epoxy17465772_epoxy
peroxy1838252peroxy
alkoxy2033343alkoxy
besom95716973beso_m
besoms105712733besoms
besot76429713beso_t
besots86415453besots
betony114211583betony
bosomy13509033bosomy
boxy166420733__boxy
dashy125612383das_hy
deadly113811473deadly
deafly13389123deafly
dearly104615323dearly
deary95826843de_ary
deathy134210233deathy
debone93714783debone
decay114718483de_cay
deco76125973deco__
decoct11313783decoct
decode104414743decode
decor84717573deco_r
decors94017773decors
decos85522123deco_s
decoys123911283decoys
decry115514353de_cry
decury1277963decury
deedy104315893de_edy
deejay1734523deejay
deeply1257013deeply
defoam1238563defoam
defog1048523defo_g
defogs1156683defogs
deform1259623deform
defray1337643defray
deftly1336533deftly
defy114921263de__fy
dehorn10439653dehorn
dehort104618103dehort
deify124112763de_ify
deity94316773de_ity
delay94820633de_lay
delly96023873de_lly
delusory1273003delusory
deluxe14197303deluxe
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
demode104013463demode
demoed103713443demoed
demon86520313demo_n
demons94917723demons
demos86022993demo_s
demote94817803demote
demy105422853de__my
denary105316863denary
denote74118043denote
densely1146713densely
densify1435293densify
density1137593density
deny86027123de__ny
deploy1237583deploy
depone93616553depone
deport94922393deport
depose94215763depose
depot85727923depo_t
depots94716343depots
deputy12426713deputy
deray95024183de_ray
derby114715343de_rby
derisory1245163derisory
derry94721373de_rry
desalt7518313desalt
desand84812633desand
desert72725493desert
desexed1636183desexed
desexes1537833desexes
design8408933design
desire7415303desire
desist74818813desist
desk95618903des__k
desks105913073des_ks
desman9311693desman
desmid1048363desmid
desmoid1137103desmoid
desorbs10437713desorbs
despoil1046523despoil
despond1137513despond
despot93413293despot
despots10319683despots
destiny113111463destiny
destroy1138153destroy
detour778193detour
detoxed1636103detoxed
detoxes1538803detoxes
detoxify2262173detoxify
devoid1189363devoid
devoir1076033devoir
devon95113683devo_n
devons104512253devons
devote104513783devote
devour1076703devour
devout10712993devout
dewax165510853dewax_
dewily1338343dewily
dewool1047403dewool
deworm1249533deworm
dewy115419023de__wy
dex116936883de__x_
dey77243373de___y
dhooly13457143dhooly
dipody1336363dipody
dishy125712353dis_hy
dismay12229473dismay
disobey1346243disobey
disown1036953disown
doby106022163d__oby
dogy96126493d__ogy
doody105517913d_oody
dooly94821803d_ooly
doomy116018263d_oomy
doozy186813713d_oozy
dopy106224153d__opy
dory85836233d__ory
doty86128223d__oty
dozy175920323d__ozy
dressy10518143dres_sy
drooly104911073drooly
droopy12458243droopy
drosky14486163drosky
drossy10528473drossy
dusky135213043dus_ky
dusty96018333dus_ty
ebony104511513_ebony
espy969373_es_py
essay867623_essay
ethoxy1933923ethoxy
felony123710323felony
foxy176517753__foxy
lemony11419553lemony
melody1237203melody
memory1338803memory
meshy135612783mes_hy
meson74118313meso_n
mesons83215843mesons
messy104913833mes_sy
methoxy2243953methoxy
oxy136320983___oxy
peony105717563pe_ony
pesky145911563pes_ky
peso66925823peso__
pesos77221623peso_s
pesty106421713pes_ty
phenoxy2243483phenoxy
poxy166820893__poxy
proxy175011013_proxy
rebody1238153rebody
recopy1339043recopy
redox134714233redox_
resay85320543res_ay
resiny94617363resiny
resoak10311093resoak
resod64720053reso_d
resods74116303resods
resold73915363resold
resole64624183resole
resorb84914353resorb
resort65728623resort
resow88217243reso_w
resown94112923resown
resows93915353resows
sensory10329093sensory
sepoy10314303sepo_y
sexy146418023__sexy
sox106444193__sox_
soy67851453__so_y
tepoy10312163tepo_y
testy85419063tes_ty
unsexy16296903unsexy
vestry1238623vestry
xerox1138623xerox_
zesty176512163zes_ty

Search took 8 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.373479064.3
2DLD Change Limit1127161917.00016102.3
3Display Results1911910.0633031.7
 (SQL Overall)1786911917.43624030.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.