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

66 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
gauntlets104287(None) 
gantlets9308901ga_ntlets
gauntlet955901gauntlet_
dauntless1033662dauntless
gantlet83616242ga_ntlet_
gauntest936602gaunt_est
gauntleted1241362gauntleted
gauntness1044202gauntness
gruntles9287232gruntle_s
mantlets104611202ma_ntlets
anklets114310413_a_nklets
annulets845813_annulets
antlers74014743_a_ntlers
auklets11298573_au_klets
aunties73920073_auntie_s
auntliest936323_auntliest
cantles94721413ca_ntle_s
countless1146373countless
cutlets94113653_cu_tlets
daunters9329853daunt_ers
faultless1243163faultless
frontlets1244233frontlets
fruitlets1243173fruitlets
gainless9117403gain_less
gallets83517403ga__llets
gannets83811443ga_n_nets
gantleted1144393ga_ntleted
garnets84115403garn__ets
gaults74112783gau__l_ts
gaunter82910713gaunt_e_r
gauntleting1351253gauntleting
gauntly1135333gauntl__y
gauntries1046033gauntries
gentles83714343g_entle_s
gentlest93410573g_entlest
grunters9359033grunt_ers
gruntle8257053gruntle__
gruntled10274943gruntle_d
guglets9369693g_u_glets
gullets84013713g_u_llets
gunless8299633g_un_less
gurglets10355543g_urglets
gustless9287683g_ustless
gutless82610713g_u_tless
guttlers9306933g_uttlers
guttles83011933g_uttle_s
hantles104117513ha_ntle_s
haunters11329543haunt_ers
jauntiest1635493jauntiest
mantelets1176813ma_ntelets
mantles94820703ma_ntle_s
mantlet93620993ma_ntlet_
martlets103310483ma_rtlets
nutlets74111253_nu_tlets
outlets73616363_ou_tlets
pantalets1147673pa_ntalets
partlets102811513pa_rtlets
plantlets1145013plantlets
roundlets10175293roundlets
rundlets9307363_rundlets
runlets73310773_run_lets
saunters82911753saunt_ers
taintless935733taintless
tartlets8289663ta_rtlets
taunters8259273taunt_ers
vaunters11327753vaunt_ers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641666.53322752.3
3Display Results66660.0164125.0
 (SQL Overall)178691666.96925640.8
 
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.