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

102 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
alkalies1215854(None) 
alkalis11148791alkali_s
alkalise12178041alkalise
alkalises13167481alkalises
alkalizes22157351alkalizes
alcaldes11114982alcaldes
alkali10127562alkali__
alkalic13146972alkali_c
alkalifies1743232alkalifies
alkalify1842822alkalify
alkalin11178182alkali_n
alkaline12168282alkaline
alkalised14155262alkalised
alkalize21177632alkalize
alkalized23146602alkalized
alkalizer22155562alkalizer
alkalizers23153952alkalizers
alkaloids1443982alkaloids
alkaloses13144852alkaloses
alkanes113812932alka_nes
alkies104518092alk__ies
allies63827672al__lies
aaliis6312903a__aliis
abbacies1445483abbacies
alanines8314803al_anines
alanins7315803al_anins
alates64833963al_a_tes
alcades101011473alca_des
alcaics1137023alca_ics
alcaides11117673alcaides
alcalde10104953alcalde_
alcaydes14133723alcaydes
alfakis1475073alfaki_s
alfalfas1441953alfalfas
aliases7914493alia_ses
alibies9313323al_ibies
alkahest1554023alka_hest
alkalified1852643alkalified
alkalinizes24142883alkalinizes
alkaloid1345293alkaloid
alkalosis13124163alkalosis
alkane104313323alka_ne_
alkanet113714433alka_net
alkanets12366233alkanets
alkenes114212753alk_enes
alkie95520033alk__ie_
alkines114415733alk_ines
alkoxides2182923alkoxides
alkylates1644703alkylates
alkylic16174233alkyli_c
alkyls13465723alkyl__s
alkynes14336463alk_ynes
allanites949803allanites
allees64521483al__lees
alleles73812033allel_es
allied74217153al__lied
ambaries123312383ambaries
angaries9314393angaries
ankles104818383ank_l_es
anomalies1149283anomalies
antalkalies1552023antalkalies
apetalies1148003apetalies
apiaries10312723apiaries
applies11311213a_pplies
argalis84214193argali_s
ataxies142410013a_taxies
aviaries1139783aviaries
balkanizes2544333balkanizes
balklines1536743balk_lines
ballies93725743bal__lies
bialies93618413_bialies
calvaries1449803calvaries
claries93422203cl_aries
dallies84023193dal__lies
fallacies1446833fallacies
galaxies1637163gal_axies
gallflies1344223gallflies
gallies84122713gal__lies
goalies8316023_goalies
kales95730983__kal_es
kalifs134410983__kalifs
ladies75124883_l_adies
lavalier1146043lavalier
lavaliers1254283lavaliers
lazies154418783_l_azies
lealties8310793_lealties
lilies63021413_l_ilies
lollies73116923_lollies
maladies11311933mal_adies
mealies92821933_mealies
platies93722543pl_aties
rallies73823343ral__lies
salaries8319573sal_aries
sallies73227813sal__lies
silkalines1443573silkalines
talkies113415733talk__ies
tallies73624603tal__lies
valkyries1952633valkyries
walies95324523__walies
walkyries1942673walkyries
wallabies1445733wallabies
wallies103320743wal__lies

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621026.69021847.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.17224915.1
 
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.