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

85 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
athlete106808(None) 
athletes1157881athletes
athletic13118652athletic
biathlete1442792biathlete
ablate82219213a_blate
accrete1137843accrete
achene11313813ach_ene
achieve1545023achieve
achiote1239213achiote
acolyte12157653acolyte
aculeate1039923aculeate
acylate12310533acylate
adhere10310333adh_ere
adulate8313233adulate
aesthete1145853aesth_ete
agamete1037403agamete
aglee65728493a_gle_e
aglet65534143a_glet_
aglets73915683a_glets
aiglet74224193aiglet_
aiglets84012913aiglets
alate55340323a__late
alee46652323a__le_e
allee54932123a_lle_e
allege74314653a_llege
allele64514563a_llele
amulet8419573amulet_
amulets939923amulets
amylene12106883amylene
analyte10158813analyte
anklet105618733anklet_
anklets114310413anklets
anolyte10159003anolyte
apholate13410473apholate
aplite8316393a_plite
applet105917433applet_
applets115710063applets
arete56031353a__rete
armlet84118193armlet_
armlets94610063armlets
ashler9459973ashle_r
ashlered1244623ashlered
ashlers10319583ashlers
ashless10318453ashless
athletics14105823athletics
atilt54828473atil_t_
atlatl637873at_latl
attrite7311833attrite
auklet104216833auklet_
auklets11298573auklets
bathless13127383bathless
biathletes1552693biathletes
bolete8519613_bolete
catheter1338153cath_eter
decathlete1652213decathlete
delete73620703_delete
deplete103010423deplete
esthete1047433esth_ete
ethene93312923eth_ene
ethylate1446223ethylate
ethylene1444233ethylene
machete14310883mach_ete
matelote1047603matelote
nathless11127023nathless
nonathlete1353303nonathlete
pathless13138043pathless
replete92912993replete
stelene7310253stelene
stylate10179773stylate
stylet94018573stylet_
stylets10369213stylets
stylite10219613stylite
tablet84227643tablet_
tableted1137533tableted
tablets94714383tablets
terete6319333_terete
thebe107515433_th_ebe
thee78039063_th_e_e
theme105921733_th_eme
there87527393_th_ere
these86519013_th_ese
theta83414573_th_eta
thieve1235963_thieve
three87526913_thre_e
triathlete1352643triathlete

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.500357382.0
2DLD Change Limit134027857.01619103.1
3Display Results85850.0302833.3
 (SQL Overall)178691857.54623680.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.