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 “gauntest” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 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
gauntest93660(None) 
bluntest1036552bluntest
faintest1139072faintest
gauchest1436292gauchest
gaudiest1039392gaudiest
gaunter82910712gaunte_r
gauntlet955902gauntlet
gauntlets1042872gauntlets
gauntness1044202gauntness
gauziest1836232gauziest
jauntiest1635492jauntiest
tautest72612442tau_test
acutest94410603_acutest
antes56334323_a_ntes_
aptest82917513_a_ptest
attest62618613_a_ttest
auldest839893_auldest
aunties73920073_aunties_
auntliest936313_auntliest
aunts55227633_aunt_s_
autist64324943_au_tist
barniest104815053barniest
canniest10313363canniest
contest93523233_contest
countess103710043countess
curtest9713963_curtest
cutest85820143_cu_test
daftest11248943da_ftest
daintiest1039153daintiest
damndest1276003damndest
dankest122611673da_nkest
darndest1067223darndest
daubiest1138233daubiest
daunted93810193daunte_d
daunter83811753daunte_r
daunters9329843daunters
dauntless1033663dauntless
daunts75014083daunt_s_
drunkest1334423drunkest
dunnest83312263_dunnest
earnest7318733earn_est
fainest10417703fain_est
fantast10311703fa_ntast
fastest102413723fa_stest
fattest102913063fa_ttest
faultiest1236093faultiest
fawniest14287443fawniest
flauntiest1343773flauntiest
funest94316863_fun_est
funfest13348083_funfest
funnest102912003_funnest
gabbiest1337273gabbiest
gabfest1336453ga_bfest
gahnites1235703gahnites_
gainless9117403gainless
gainliest1037133gainliest
gainst74914693gain__st
gamest94919923ga__mest
gametes10312253gametes_
gamiest102816223ga_miest
gammiest13339323gammiest
gannet74321853ga_nne_t
gannets83811443gannets_
gantlet83616243ga_ntlet
gantlets9308903ga_ntlets
gappiest13259473gappiest
garnet73928413garn_e_t
garnets84115403garnets_
garotes8614563garotes_
gashest114813413ga_shest
gassiest93212523gassiest
gastness9278473gastness
gates65939503ga__tes_
gaudies9311973gaudies_
gauges85915993gau_ges_
gaults74112783gault_s_
gaunt65430403gaun___t
gauntly1135333gaunt_ly
gauntries1046033gauntries_
gauntry1154113gaunt_ry
gausses8308693gausses_
gauzes164710633gau_zes_
gawkiest16327313gawkiest
gayest104314333ga__yest
gayness1136843gayn_ess
gentes75324163g_entes_
gentlest93410573g_entlest
giantess933893giantess
ginniest92610503ginniest
glintiest1037623glintiest
gluiest839773glu_iest
glummest13235563glummest
glutes74517673glu_tes_
gooniest93213003gooniest
goutiest93013883goutiest
grainiest10188993grainiest
grandest10311573grandest
greatest939863greatest
gruffest1544583gruffest
grummest13286363grummest
grunges93310403grunges_
grungiest1135803grungiest
grunted9339283grunte_d
grunter83110783grunte_r
grunters9359023grunters
gruntles9287233gruntles_
grunts75511853grunt_s_
guest65225923g_u__est
gunites8313123g_unites_
gunkiest132610573g_unkiest
gunless8299633g_unless
gustiest92914523g_ustiest
guttiest92311223g_uttiest
haunted11399733haunte_d
haunter103111153haunte_r
haunters11329533haunters
haunts95614393haunt_s_
jaunces16307423jaunces_
jaunted15418563jaunte_d
jaunts137511883jaunt_s_
justest1449893_justest
lankest112714113la_nkest
latest63822703la__test
launces9329003launces_
luniest73516993_luniest
mantes84430783ma_ntes_
minutest10247653minutest
mutest84218053_mu_test
paintiest11310563paintiest
puniest92918093_puniest
punkest132611693_punkest
quaintest1845343quaintest
rainiest81214923rainiest
rankest112713813ra_nkest
roundest9310473roundest
runtiest83014513_runtiest
saltest71916513sa_ltest
sanest64426693sa_n_est
sauciest10310963sauciest
saunter72913453saunte_r
saunters82911743saunters
sautes63924913sau_tes_
scantest101710183scantest
soundest9510973soundest
squintest1845693squintest
subtest9513963_subtest
tannest72617853ta_nnest
tartest72517533ta_rtest
taunted84310963taunte_d
taunter73111453taunte_r
taunters8259263taunters
taunts65715663taunt_s_
tautness8217183tautness
tawniest11279343tawniest
unrest62918853__unrest
vainest10315763vain_est
vastest102911513va_stest
vaultiest1234833vaultiest
vaunted11438863vaunte_d
vaunter10309603vaunte_r
vaunters11327743vaunters
vaunts95212623vaunt_s_
waniest103819113wa_niest
wannest103915003wa_nnest
wattest102412153wa_ttest
youngest1244903youngest
zaniest163214773za_niest

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.1731032896.0
2DLD Change Limit1461621677.28020077.2
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.51623774.7
 
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.