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

143 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
alidads93629(None) 
alidad838881alidad_
alidade936991alidade
alidades1037001alidades
alias55834602ali_a_s
alipeds10386792alipeds
aliyahs13395322aliyahs
aliyas93911802aliya_s
aoudads973762aoudads
audads8167102a_udads
iliads7448672ili_ads
lidars7310782_lidars
abided105313313abided_
abiders104011083abiders
abides94719893abid_es
acidheads1642653acidheads
acids87121003aci__ds
adds67622453a__d_ds
agitas7310593agita_s
aided75828933a_ided_
aiders74524633a_iders
aides65336603a_id_es
aids57846363a_i__ds
ajivas1655133ajiva_s
alands75418373al_ands
alans55636173al__ans
alas46358123al__a_s
albas75925393al_ba_s
alcade91111513al_cade
alcades101011473alcades
alcids94812293al_cids
alders74218423al_ders
aldols7109713al_dols
alegars838933alegars
alfas87219043al_fa_s
algas65624933al_ga_s
aliases7914493aliases
alibies9313323alibies
alibis8311073ali_bis
aliens65619213ali_ens
alifs86121263ali__fs
alights113211433alights
aligns75312953ali_gns
alined75221403alined_
aliners74717723aliners
alines65735223ali_nes
aliped95414283aliped_
aliunde835003aliunde
aliya83713483aliya__
aliyah12397493aliya_h
aliyos9349533ali_yos
alkyds14404363al_kyds
allays94313743al_lays
allods73615083al_lods
almahs118611613al_mahs
almas76629773al_ma_s
almonds10127953almonds
almuds9378773al_muds
alohas9411703aloha_s
alphas1139513alpha_s
already1144263already
altars64518153al_tars
aludels835303aludels
always12409133al_ways
amias75831473ami_a_s
amidase1036733amidase
amidases1136653amidases
amides95722663amid_es
amidins103713103amidins
amidols10457563amidols
amids85627513ami__ds
amigas95912173amiga_s
animals94111703animals
animas84418723anima_s
aoudad835043aoudad_
apicals1159923apicals
arias55438023ari_a_s
asides75118873asid_es
audad71511393a_udad_
avians93711563avi_ans
avidins11349003avidins
azides165113803azid_es
ballads104212913bal_lads
blinds95111613bli_nds
bridals1038623bridals
clads85722733cl__ads
dads67442773___dads
doodads1035093doodads
elided84814673elided_
elides74420693elid_es
glads75620613gl__ads
glias64618493gli_a_s
glided94513903glided_
gliders94811843gliders
glides84518863glid_es
halides113416663halid_es
halidoms1485823halidoms
halids104016133hali__ds
helipads1443873helipads
hodads1147963_hodads
holidays1544103holidays
iliad64613463ili_ad_
jihads1734483_jihads
kalians11310183kali_ans
lads56549133_l__ads
lairds74711613lai_rds
lampads12477623lampads
landaus8310343landaus
leads66028493_l_eads
liards75212613_liards
liars54723163_li_ars
lidar6312723_lida_r
lidos65219883_lid_os
lids56336463_li__ds
ligands9438983_ligands
ligans76817733_ligans
lilacs837483_lilacs
limans84816303_limans
limas75627633_lima_s
linacs8310813_linacs
lipids94310923_lipids
liras56021983_lira_s
litas54923773_lita_s
lizards17427613_lizards
loads65323373_l_oads
naiads739013nai_ads
nicads938333_nicads
palikars1445083palikars
palisade1145833palisade
palisades1245613palisades
pleads94613953pl_eads
pleiads1045223pleiads
salads75316963sal__ads
salinas73116093salina_s
salivas10309603saliva_s
sialidans1042973sialidans
sliders83515223sliders
slides73922183slid_es
talipeds1183553talipeds
triads74513533tri_ads
validate1239003validate
validates1338243validates
whidahs1743333whidahs

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271436.70619986.1
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.15524974.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.