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

77 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
athletes115788(None) 
athlete1068081athlete_
athletic13118642athletic
athletics14105812athletics
biathletes1552692biathletes
ablates92416903a_blates
accretes1238113accretes
achenes12313493ach_enes
achieves1645523achieves
achiotes1339003achiotes
acolytes13168033acolytes
acylates1339743acylates
adheres11310163adh_eres
adulates9311913adulates
aesthetes1246233aesth_etes
agametes1147293agametes
aglets73915683a_glet_s
aiglets84012913aiglet_s
alates64833963a__lates
allees64521483a_lle_es
alleges84212563a_lleges
alleles73812033a_lleles
amulets939923amulet_s
amylenes13105703amylenes
analytes11169203analytes
anklets114310413anklet_s
anolytes11169203anolytes
antheses11311473anth_eses
apheses12610703aph_eses
apholates1449683apholates
aplites9314933a_plites
applets115710063applet_s
aretes64425353a__retes
armlets94610063armlet_s
ashlered1244623ashlered
ashlers10319583ashle_rs
ashless10318453ashle_ss
athetoses1244973ath_etoses
atlantes838553atlantes
atlases72410643at_lases
atlatls744773at_latls
attrites8311563attrites
auklets11298573auklet_s
bathless13127383bathle_ss
biathlete1442793biathlete_
boletes9316063_boletes
catalexes1845913catalexes
catheter1338153cath_eter
catheters1436993cath_eters
cathexes2036273cath_exes
decathletes1752343decathletes
deletes83117933_deletes
depletes112810633depletes
esthetes1147743esth_etes
ethenes103313873eth_enes
ethylates1545903ethylates
ethylenes1544203ethylenes
machetes1539633mach_etes
matelotes1146333matelotes
nathless11127023nathle_ss
nonathletes1453193nonathletes
pathless13138043pathle_ss
repletes102812463repletes
stylets10369213stylet_s
stylites11168693stylites
tableted1137533tableted
tablets94714373tablet_s
teleses7313123_teleses
telexes1438343_telexes
thebes115914493_th_ebes
themes115319253_th_emes
theres96525473_th_eres
theses96517973_th_eses
thetas93011573_th_etas
thieves1346903_thieves
threes97117323_thre_es
triathletes1472283triathletes

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.1561145455.1
2DLD Change Limit146162777.93618417.6
3Display Results77770.0302566.7
 (SQL Overall)178691778.12222000.9
 
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.