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

241 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
alanyl95548(None) 
alanyls1084351alanyls
adenyl1035022adenyl
alan46844082alan__
aland65526412alan_d
alands75418372alands
alane56135612alan_e
alang66023512alan_g
alanin6317272alanin
alans55636172alan_s
alant55742292alan_t
alants67722022alants
alary86123442alary_
alkyl12518042al_kyl
allyl85310542al_lyl
alphyl1484082alphyl
uranyl936292uranyl
aal39058673a_a__l
abaya104413173aba_ya
acetyl11396553acetyl
acyl95314293__acyl
adenyls1143923adenyls
agnail739533agnail
agonal7410053agonal
agony96415653agony_
ala312463603ala___
alack114820063ala_ck
alae45643753ala__e
alamo7418143ala_mo
alamos8415003alamos
alanine7316863alanine
alanins7315803alanins
alar46340073ala__r
alarm76621423ala_rm
alarms85913053alarms
alarum85411983alarum
alas46358123ala__s
alaska1036713alaska
alate55340333ala_te
alated75625153alated
alates64833973alates
albinal937813albinal
aldol61212333al_dol
algal66518223al_gal
alienly1037503alienly
aline57243153alin_e
alined75221403alined
aliner65621983aliner
alines65735223alines
aliya83713483al_iya
alkane104313323alkan_e
alkanes113812933alkanes
alkanet113714433alkanet
alky115920343al_ky_
alkyd13537093al_kyd
alkyls13465723al_kyls
alkyne13436863alkyne
all36148233al___l
allay85620393allay_
allays94313743allays
alley85721673alley_
alleys95113303alleys
allonym1244733allonym
alloy85519973alloy_
alloys94014563alloys
ally76935643al_ly_
allyls9437273al_lyls
almanac1156033almanac
almner85710723almner
alone55732963alon_e
along65419493alon_g
alphyls15113953alphyls
aludel747863aludel
alway116113923alway_
always12409133always
amatol838693amatol
amyl95515103__amyl
anal48037523__anal
anally9513503anally
ananke1038283ananke
anil46437433__anil
annal56520763a_nnal
annul55813383a_nnul
anonym1136383anonym
any68440493__any_
aryl75922343__aryl
asana5315483asan_a
asanas6514113asanas
aslant6317753aslan_t
atabal839743atabal
ataxy1537313ataxy_
atlatl637873atla_tl
atonal6514023atonal
atony87218853atony_
avail8313883ava_il
avant86224663avan_t
away108024223awa_y_
awny105919303a_wny_
axal116520493axa__l
axonal1347653axonal
azan136521783azan__
azans146516883azan_s
azonal1568273azonal
balance11510263balance
banal75925993_banal
blanch133410853blanch
bland85320453blan_d
blandly1336043blandly
blank115418553blan_k
blankly1634263blankly
blanks124112893blanks
calando1037383calando
canal75428043_canal
clan65633923clan__
clang86019313clan_g
clangs95113613clangs
clank114719523clan_k
clanks124615183clanks
clanky15469073clanky
clans75031013clan_s
clary105719613clary_
clay95927413cla_y_
clays105521333cla_ys
cleanly1236323cleanly
clinal8311553clinal
clonal8310913clonal
elan46734243elan__
eland65820393elan_d
elands74914773elands
elans55527753elan_s
falafel1383903falafel
flail85316183fla_il
flaky155715583flaky_
flamy135217473flamy_
flan76134183flan__
flanes94522423flanes
flange103411973flange
flank124618093flan_k
flanks133913403flanks
flannel1035423flannel
flans85327973flan_s
flatly123110213flatly
flawy145913383flawy_
flaxy189012293flaxy_
flay106332803fla_y_
flays116321053fla_ys
galanga936023galanga
galangal1043893galangal
galaxy17476313galaxy_
gladly11497933gladly
glady105413943glady_
glance94312313glance
gland75217713glan_d
glands85314403glands
glans65125833glan_s
glary96018543glary_
glazy187410983glazy_
glycyl1542793glycyl
halal85623593hala__l
label75019383_label
lacy95829633_lacy_
lady86527153_lady_
laky116725823_laky_
lall45531313_la_ll
lanai5319573_lanai
lance75126723_lance
land56337313_lan_d
lands65426903_lands
lane45153333_lan_e
lanely93914483_lanely
lanes54946793_lanes
lang56637383_lan_g
lank84734453_lan_k
lankly13439623_lankly
lanky125517483_lanky
lapel73716683_lapel
lawny115912013lawny_
laxly15610103_laxly
lay68865353_la_y_
lays76043253_la_ys
lazy166423073_lazy_
leanly93811503leanly
liny78141323_liny_
llano5910603llan_o
llanos6108333llanos
luny77324133_luny_
malady1237863malady_
malanga1036663malanga
manly105022953_manly
many95731863_many_
meanly115412043meanly
meany104620483meany_
nonyl849773_nonyl
palatal9310153palatal
panel76023623_panel
phenyl1435323phenyl
plagal948573plagal
plainly1236473plainly
plan65833943plan__
planar84212713planar
planch133711443planch
plane74929143plan_e
planed94420913planed
planer84122653planer
planes85028083planes
planet84228353planet
plank115221143plan_k
planks124116753planks
plans75731273plan_s
plant75437113plan_t
plants84921803plants
planula935773planula
platy105021663platy_
platys11459853platys
play95928983pla_y_
playa105812943pla_ya
plays106320773pla_ys
ratany93411873ratany_
salably121610743salably
salal55425703sala__l
salary9515213salary_
slang66324023slan_g
slangs75615343slangs
slangy105411393slangy
slank95822773slan_k
slant55238703slan_t
slantly10399323slantly
slants64819083slants
slanty95114843slanty
slaty86523153slaty_
slay76436383sla_y_
slays85723683sla_ys
stanol6310723stanol
ulan46527393ulan__
ulans54921303ulan_s
uranyls1034453uranyls
valance1269253valance
vinyl115311623_vinyl
wanly115118023_wanly
wany106432363_wany_
zany167316993_zany_

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.373479064.3
2DLD Change Limit1127162415.19021717.9
3Display Results2412410.0932591.4
 (SQL Overall)1786912415.65631593.2
 
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.