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

50 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
alcaydes1413372(None) 
alcades101011471alca_des
alcaides11117671alcaides
alcaldes11114981alcaldes
alcayde13103721alcayde_
alcade91111512alca_de_
alcaide1088452alcaide_
alcalde10104952alcalde_
arcades101113192arca_des
abrades10312073abra_des
accedes1237713a_ccedes
acnodes1037823a_cnodes
alamodes1148013alamodes
alands75418373al_and_s
alates64833963al_a_tes
alcahest1345353alca_hest
alcaics1137023alca_ics
alcazars1942963alcazars
alchymies1942883alchymies
alcids94812293alc_id_s
alcoves1297873alc_oves
aldehydes1752293aldehydes
aliases7914493alia_ses
alidades1037003alidades
alkalies12158543alkalies
alkanes113812933alka_nes
alkyds14404363al_kyd_s
alkynes14336463al_kynes
allayed11138063allay_ed
allayer10148213allay_er
allayers11156633allayers
allays94313743allay__s
alludes83610333al_ludes
almudes10418263al_mudes
always12409133alway__s
arcade91013643arca_de_
arcaded1178973arca_ded
ascarides12346953ascarides
aubades1038743auba_des
ballades114211643balla_des
blades95221253bl_a_des
cades85440733__ca_des
cascades13128553casca_des
clades94920463cl_a_des
decades113615503deca_des
facades1339033faca_des
glades84820343gl_a_des
glandes95413833gl_andes
lades65141273_l_a_des
saccades13137243sacca_des

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.1531167915.0
2DLD Change Limit146162508.44017317.8
3Display Results50500.0163125.0
 (SQL Overall)178691508.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.