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

115 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
alkoxy203334(None) 
alky115920342alk__y
alloy85519972allo_y
agony96415653a_gony
ahoy101919183a_ho_y
alary86123443al_ary
alcove1178083alcove
aldol61212333aldo_l
aldols7109713aldols
aldose7311093aldose
algoid83011473algoid
algor6513053algo_r
algors7312553algors
alimony1236013alimony
alkali10127563alkali
alkane104313323alkane
alkene104114003alkene
alkie95520033alk_ie
alkies104518093alkies
alkine104916803alkine
alkoxide2083213alkoxide
alkyd13537093alk_yd
alkyds14404363alkyds
alkyl12518043alk_yl
alkyls13465723alkyls
alkyne13436863alkyne
allay85620393al_lay
alley85721673al_ley
allod64418383allo_d
allods73615083allods
allonym1244733allonym
allot54933873allo_t
allots64019173allots
allow85420663allo_w
allows94517683allows
alloxan1445773alloxan
alloys94014563alloys
ally76935643al__ly
almond91410433almond
almondy13144483almondy
almonry12104733almonry
almost81014433almost
aloe45540193al_o_e
aloes54933673al_oes
aloft8423433al_oft
aloha8513613al_oha
aloin55227423al_oin
alone55732963al_one
along65419493al_ong
aloof83521573al_oof
aloofly1343623aloofly
aloud65018073al_oud
alow75328593al_o_w
also46423443also__
alto47831263alto__
altos55822953alto_s
alway116113923al_way
annoy869713anno_y
anomy105113393a_nomy
argosy1036423argosy
arkose104911343arkose
armory114211473armory
arrowy12288273arrowy
askoi9507803asko_i
askos95011773asko_s
astony9510523astony
ataxy1537313a_taxy
atomy107415193a_tomy
atony87218853a_tony
atopy106813393a_topy
balcony1435853balcony
balkily16266693balkily
balky145418243balk__y
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
blowy134315323bl_owy
boxy166420733__boxy
calory11312843cal_ory
cloy96623833cl_o_y
deoxy1648883_deoxy
desoxy1744623desoxy
doxy156419953__doxy
epoxy17465773_epoxy
ethoxy1933923ethoxy
flaxy189012293fl_axy
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
foxy176517753__foxy
galaxy17476313gal_axy
gloomy12528763gloomy
glory96413293gl_ory
jalopy18325863jal_opy
kolkozy2262143kolkozy
laky116725823lak__y
logy87025783_l_ogy
looby108115623_looby
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
lory75931713_l_ory
lox108240963_l_ox_
ology94113113ol_ogy
oxy136320983___oxy
peroxy1838253peroxy
ploy96123603pl_o_y
poxy166820893__poxy
proxy175011013_proxy
sallowy13369343sallowy
talky126215683talk__y
tallowy13347633tallowy
walkout1447933walkout
walkway2043373walkway
zloty17399793zl_oty

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.393454684.5
2DLD Change Limit1127161155.50020493.8
3Display Results1151150.0303833.3
 (SQL Overall)1786911155.92330169.0
 
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.