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

113 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
alcaides1111767(None) 
alcades101011471alca_des
alcaide1088451alcaide_
alcaldes11114981alcaldes
alcaydes14133721alcaydes
alcade91111512alca_de_
alcaics1137022alcai_cs
alcalde10104952alcalde_
alcayde13103722alcayde_
alcids94812292alc_id_s
arcades101113192arca_des
ascarides12346952ascarides
abides94719893a__bides
abrades10312073abra_des
acarids105312243a_carid_s
acarines10314343a_carines
accedes1237713a_ccedes
accidies1338043a_ccidies
acids87121003a_c_id_s
acnodes1037823a_cnodes
acrider1038623a_crider
acridest1138143a_cridest
actives12311523a_ctives
affaires1444303affaires
aides65336603___aides
alamodes1148013alamodes
alands75418373al_and_s
alanines8314803alanines
alates64833963al_a_tes
albites9313203al_bites
alcahest1345353alca_hest
alcaic1039983alcai__c
alcazars1942963alcazars
alcid85817973alc_id__
alcoves1297873alc_oves
alewives1444283alewives
alexines15258503alexines
algaecides1451933algaecides
algicides1344863algicides
aliases7914493alia_ses
alibies9313323alibi_es
alidades1037003alidades
alines65735223al__ines
alkalies12158543alkalies
alkalises13167483alkalises
alkalizes22157353alkalizes
alkanes113812933alka_nes
alkies104518093al_ki_es
alkines114415733al_kines
alkoxides2182913alkoxides
allanites949803allanites
allies63827673al_li_es
alludes83610333al_ludes
almudes10418263al_mudes
alpines94016193al_pines
alsikes1137263al_sikes
alumines10411683alumines
alunites8310703alunites
amides95722663a__mides
aphides134711203a_phides
apsides103911303a_psides
arcade91013643arca_de_
arcaded1178973arca_ded
arcadias1149163arcadias
archaises1448403archaises
archaizes2346443archaizes
archines133815253archines
archives16399553archives
arcsines104010343arcsines
ascarids11438503ascarid_s
ascites9312603asc_ites
ascribes1246193ascribes
asides75118873a__sides
aubades1038753auba_des
azides165113803a__zides
ballades114211643balla_des
blades95221253bl_a_des
cades85440733__ca_des
caids85226423__caid_s
calcines12314753calc_ines
calcites12313003calc_ites
cascades13128553casca_des
chides124620473__chides
clades94920463cl_a_des
cocaines121314443cocaines
decades113615513deca_des
decides114217653dec_ides
elides74420693el__ides
eucaines1038513eucaines
excides1738343exc_ides
facades1339033faca_des
glacises1138503glacises
glades84820343gl_a_des
glaires84010133gl_aires
glaives11347833gl_aives
glandes95413833gl_andes
glides84518863gl__ides
halides113416663hal__ides
lades65141273_l_a_des
ladies75124883_l_adies
lapides103012043_lapides
liaises7311053_liaises
lipides103810623_lipides
maladies11311933mal_adies
malaises10312333mal_aises
nuclides1146553nuclides
plaices11411143pl_aices
plaided11409643pl_aided
plaids94312443pl_aid_s
pleiades1145753pleiades
rachides141511223rachides
saccades13137253sacca_des
slides73922183sl__ides

Search took 9 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.1561145455.1
2DLD Change Limit1461621137.86018595.7
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.06222164.6
 
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.