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

251 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
allaying1233930(None) 
alloying12339141alloying
allying113011661all_ying
ablating11311992ablating
aliasing9310072aliasing
alleging1038472alleging
allowing12369092allowing
alluding1036952alluding
alluring939072alluring
arraying1238752arraying
assaying1236002assaying
belaying143110602belaying
claying133614302_claying
dallying13368492dall_ying
delaying133210972delaying
flaying143914462_flaying
gallying13328932gall_ying
inlaying1247892inlaying
laying104525702__laying
parlaying1537302parlaying
playing133816092_playing
rallying12289012rall_ying
relaying122515152relaying
sallying12309852sall_ying
slaying113316842_slaying
splaying14219302splaying
tallaging1146482tallaging
tallying12318832tall_ying
unlaying1258362unlaying
waylaying1953102waylaying
aahing1019015763a__ahing
abasing10610673a_basing
abating10413973a_bating
abrading1239503abrading
abying124410413a__bying
acylating1547563acylating
adulating1178713adulating
aerating92821003aerating
affraying1943103affraying
ailing74331013ail__ing
alang66023513a_la__ng
alanin6317273a_lanin_
alanine7316863a_lanine
alanins7315803a_lanins
alarming1138583alarming
alerting91312383alerting
aliasings1043653aliasings
alibiing1135323alibiing
aliening91510893aliening
aligning10158533aligning
alining81917043a_lining
alkalin11178183alkalin_
alkaline12168283alkaline
alkylating1843533alkylating
allanite8411093allanite
allay85620393allay___
allayed11138063allay_ed
allayer10148213allay_er
allayers11156633allayers
allays94313743allay__s
allicin949953allicin_
allicins1049653allicins
allocating1347383allocating
allotting1046503allotting
altering91917113altering
amazing1938813a_mazing
analysing1345933analysing
analyzing2245153analyzing
anearing9413973anearing
annoying1246543annoying
applying1634653applying
arcading1239763arcading
ashlaring1344493ashlaring
aviating12311013aviating
awaking1547813a_waking
ballasting1345283ballasting
balling104424763ball__ing
balloting1238383balloting
balsaming1445123balsaming
baying125222583__baying
beladying1634763beladying
bellying14359073bellying
belying133612443bel_ying
blading113615363_blading
blaming123515693_blaming
blaring104317113_blaring
blawing134012753_blawing
blazing193612393_blazing
blearing113111943blearing
bleating113514503bleating
bloating113512813bloating
braying134416313_braying
bullying14329293bullying
calling103826773call__ing
callusing1236173callusing
cellaring1238523cellaring
clawing133812673_clawing
cleaning113112383cleaning
clearing113014883clearing
cleating113518133cleating
cleaving141389683cleaving
cloaking15299713cloaking
cloying133511753_cloying
collaging1337913collaging
collaring12310543collaring
collating12312763collating
collying14319543collying
cullying14297503cullying
decaying15239453decaying
delating103119603delating
dilating102714903dilating
dollying13407413dollying
draying123813843_draying
elating83423083_elating
embaying1635263embaying
enlacing1148773enlacing
essaying1235033essaying
falling113621583fall__ing
fallowing1666433fallowing
faying134521073__faying
fellating1339243fellating
flaking154114493_flaking
flaming134216443_flaming
flaring114116803_flaring
flawing143812563_flawing
fleying14329873_fleying
floating123111883floating
flying134612153_fl_ying
foraying1537433foraying
fraying143413433_fraying
gallamine1246123gallamine
gallanting1245343gallanting
gallerying1543033gallerying
galleting1137623galleting
galling93921963gall__ing
galloping1356253galloping
gelating103015733gelating
gillying13306813gillying
glaring93714883_glaring
glazing183611003_glazing
gleaming12277933gleaming
gleaning10269323gleaning
gleying12318433_gleying
gloaming12268013gloaming
gloating102611463gloating
glorying1335543glorying
graying124115883_graying
gullying13367243gullying
halloaing1387033halloaing
halloing121510073hall_oing
hallooing1366343hallooing
hallowing1676943hallowing
haying134420613__haying
hollaing12167093holla_ing
illuding1035803illuding
illuming1135873illuming
inlacing1158373inlacing
inlying1168153inl_ying
jellying19306173jellying
jollying19316053jollying
lacing94626233__lacing
lading84227123__lading
laking115027043__laking
lalling83519623lal_ling
laming94528363__laming
lasing74727983__lasing
laving104623573__laving
lawing104625283__lawing
layin84720333__layin_
layins93817653__layins
lazing164821473__lazing
lazying2046673_lazying
leading93419553_leading
leafing113313583_leafing
leaking123616973_leaking
leaning83721203_leaning
leaping103215993_leaping
leasing83920163_leasing
leaving114216853_leaving
levying1435873_levying
loading94114613_loading
loafing11319793_loafing
loaming103613733_loaming
loaning83614833_loaning
lullabying1641383lullabying
lying95717453__l_ying
malling103623663mall__ing
maying124421153__maying
mislaying1557913mislaying
naysaying1642983naysaying
okaying1534833_okaying
outlaying1338543outlaying
palleting1238733palleting
palliating1347883palliating
palling104024483pall__ing
palpating1438533palpating
palsying1436233palsying
parleying1536113parleying
paying123722163__paying
pillaging1345553pillaging
pillaring1237643pillaring
placing123815283_placing
planing103418253_planing
plating103823073_plating
pleading123011443pleading
pleasing112611593pleasing
pleating112916053pleating
ploying132811573_ploying
plying124312083_pl_ying
praying133717323_praying
rallyings13313633rall_yings
raying105027193__raying
relacing112516043relacing
relating92725443relating
relaxing162612633relaxing
relying112914613rel_ying
repaying142712393repaying
replaying15259603replaying
resaying122512453resaying
salaaming1265363salaaming
salarying1336073salarying
salifying1636333salifying
sallowing1357383sallowing
salvaging1465283salvaging
sashaying1644593sashaying
saying104325543__saying
slaking123717473_slaking
slating83724653_slating
slaving113514833_slaving
sleaving123310983sleaving
solacing11310133solacing
solating9315593solating
spaying133014623_spaying
spraying14299883spraying
staying114017323_staying
straying122912693straying
sullying12328513sullying
swaying143610643_swaying
tallowing1366293tallowing
taxpaying2242343taxpaying
ululating1036643ululating
unlacing1148643unlacing
unlading1058863unlading
unpaying1456943unpaying
unsaying1288153unsaying
valuating1338643valuating
volleying1643763volleying
walling113520973wall__ing
walloping1545593walloping
wallowing1666073wallowing
willying15306713willying

Search took 7 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461622516.37622923.8
3Display Results2512510.1102281.8
 (SQL Overall)1786912516.63926915.3
 
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.