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

82 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
gauntlet95590(None) 
gantlet83616241ga_ntlet
gauntlets1042871gauntlets
gantlets9308902ga_ntlets
gaunter82910712gaunt_er
gauntest936602gauntest
gauntleted1241362gauntleted
gauntly1135332gauntl_y
gruntle8257052gruntle_
gruntled10274942gruntled
gruntles9287232gruntles
mantlet93620992ma_ntlet
anklet105618733_a_nklet
annulet7311593_annulet
antler64615553_a_ntler
auklet104216833_au_klet
auntie64317703_auntie_
aunties73920073_aunties
auntlier834903_auntlier
auntliest936323_auntliest
auntly95211063_auntl_y
cantle84522153ca_ntle_
cantles94721413ca_ntles
cutlet84924363_cu_tlet
daunted93810193daunt_ed
daunter83811753daunt_er
dauntless1033663dauntless
frontlet1147653frontlet
fruitlet1146883fruitlet
gallet73630853ga__llet
gannet74321853ga_n_net
gantleted1144393ga_ntleted
garnet73928413garn__et
gault65128483gau__l_t
gaunt65430403gaun___t
gauntleting1351253gauntleting
gauntness1044203gauntness
gauntries1046043gauntries
gauntry1154113gaunt_ry
gentle74014513g_entle_
gentled9389093g_entled
gentler8378953g_entler
gentles83714343g_entles
gentlest93410573g_entlest
grunted9339283grunt_ed
grunter83110783grunt_er
guglet84018223g_u_glet
gullet74924833g_u_llet
gurglet94412033g_urglet
guttle74111973g_uttle_
guttled9378993g_uttled
guttler8369163g_uttler
guttles83011933g_uttles
hantle94318203ha_ntle_
hantles104117513ha_ntles
haunted11399733haunt_ed
haunter103111153haunt_er
jaunted15418563jaunt_ed
jauntier1535233jauntier
jauntiest1635493jauntiest
mantelet10613823ma_ntelet
mantle84420923ma_ntle_
mantled104113393ma_ntled
mantles94820703ma_ntles
mantlets104611203ma_ntlets
martlet93419153ma_rtlet
nutlet64220563_nu_tlet
outlet63728683_ou_tlet
pantalet10415903pa_ntalet
partlet92720363pa_rtlet
plantlet10310013plantlet
roundlet9209223roundlet
rundlet83114153_rundlet
runlet63821413_run_let
saunter72913453saunt_er
tartlet72218483ta_rtlet
taunted84310963taunt_ed
taunter73111453taunt_er
unlet54133333__un_let
vaunted11438863vaunt_ed
vaunter10309603vaunt_er
vauntie1036633vauntie_

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 Filter1786911461620.470380193.6
2DLD Change Limit146162827.32619951.1
3Display Results82820.0332484.8
 (SQL Overall)178691827.82922824.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.