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 “alcayde” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
alcayde1310372(None) 
alcade91111511alca_de
alcaide1088451alcaide
alcalde10104951alcalde
alcaydes14133721alcaydes
alcades101011472alca_des
alcaides11117672alcaides
alcaldes11114982alcaldes
allayed11138062allayed
arcade91013642arca_de
abrade9313053abra_de
accede1138293a_ccede
acnode938193a_cnode
alae45643753al_a__e
alamode1038153alamode
aland65526413al_and_
alands75418373al_ands
alane56135613al_a_ne
alate55340323al_a_te
alated75625143al_ated
alcaic1039983alca_ic
alcaics1137023alcaics
alcazar1843453alcazar
alchymy2041843alchymy
alcid85817973alc_id_
alcids94812293alc_ids
alcove1178083alc_ove
alcoved1375613alcoved
aldehyde1642273aldehyde
algae65319623alga__e
alidade936993alidade
aliunde835003aliunde
alkane104313323alka_ne
alkyd13537093al_kyd_
alkyds14404363al_kyds
alkyne13436863al_kyne
allay85620393allay__
allayer10148213allayer
allays94313743allay_s
alloyed11158033alloyed
allude73910903al_lude
almude9399933al_mude
alway116113923alway__
always12409133alway_s
arcaded1178973arca_ded
arcades101113193arca_des
arcane81216743arca_ne
arrayed11117153arrayed
ascared10399523ascared
assayed1135593assayed
aubade939223auba_de
ballade104012563balla_de
blade85923333bl_a_de
cade76443913__ca_de
cascade12118603casca_de
clade85821013cl_a_de
clayed125013043cl_ayed
decade104216163deca_de
decayed14309333decayed
facade1238803faca_de
falcate12311613falca_te
falcated1438473falcated
flayed134414053fl_ayed
glade75121963gl_a_de
lade56345983_l_a_de
layed95127383_l_ayed
played124815033pl_ayed
saccade12107033sacca_de
slayed104716223sl_ayed

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.1561145455.1
2DLD Change Limit134027697.25318478.8
3Display Results69690.0135307.7
 (SQL Overall)178691697.42224075.9
 
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.