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

68 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
alencon94573(None) 
alencons1045481alencons
aleuron757382aleuron
ancon75718232a__ncon
abandon1045463abandon
aeon45634613a_e__on
agency1237033agenc_y
aglycon1342783aglycon
aileron739833aile_ron
alanin6317273alan_in
alation72920553alation
alec66430063ale_c__
alecs76620733ale_c_s
aleurone846113aleurone
aleurons867013aleurons
alevin92511513ale_vin
alexin132311483ale_xin
alienor7116303alien_or
allicin949953allicin
alnico877943alnico_
alnicos985533alnicos
alpenhorn1452093alpenhorn
amelcorn1243223amelcorn
amnion84812053a_mnion
ancone83916953a__ncone
anion55028813a__nion
anon46134853a__n_on
anyon85615223a__nyon
beacon10511373_beacon
blench133710453blenc_h
clench133910053clenc_h
deacon9510423_deacon
elenchi1244713elenchi
elevon977953ele_von
falcon11310293fal__con
flacon1138633fl_acon
flench144010813flenc_h
fleuron1055573fleuron
flexion1735073flexion
guenon736403guen_on
helicon1237643helicon
legion75712983_legion
lemon75618183_le_mon
leno47331393_len_o_
lenos56024863_len_os
lenten6312883_lenten
lento57223393_lento_
lentos65317403_lentos
lepton82510803_lepton
lesion64715063_lesion
lesson64412043_lesson
leucin839113_leucin
leukon1036143_leukon
lexicon1643903_lexicon
neocon836713_neocon
pennon8310643_pennon
plench134010813plenc_h
pleon74216383ple__on
pleuron976343pleuron
prenoon9310043prenoon
recon75624243_re_con
tendon7312033_tendon
tenon53320513_ten_on
valence1268773valenc_e
valences1388513valences
valencia1343763valencia
valency1565463valenc_y
xenon122612453_xen_on

Search took 7 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.390458182.1
2DLD Change Limit134027686.26621389.6
3Display Results68680.0164250.0
 (SQL Overall)178691686.67226782.2
 
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.