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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
saunters8291175(None) 
daunters9329851daunters
haunters11329541haunters
saunter72913451saunter_
shunters113210751shunters
taunters8259271taunters
vaunters11327751vaunters
banters94623112ba_nters
bunters94717122_bunters
canters94827732ca_nters
chaunters1455822chaunters
chunters133910902chunters
counters103320192counters
daunders10278472daunders
daunter83811752daunter_
fainters11349692fainters
flaunters1234512flaunters
gaunter82910712gaunter_
grunters9359032grunters
haunter103111152haunter_
hunters103915732_hunters
launders9358742launders
maunders11348342maunders
mounters103712502mounters
painters103013022painters
punters93617042_punters
ranters73323642ra_nters
salters73622252sa_lters
saluters8319862saluters
sanders84025942sa_nders
sangers84421942sa_ngers
santera7311302sa_ntera
santeras8311062sa_nteras
santero7311132sa_ntero
santeros8311192sa_nteros
santirs7312962sa_ntirs
santurs7310762sa_nturs
saucers93712132sau_cers
sauciers1076732sauciers
saugers83914052sau_gers
sauntered1036282sauntered
saunterer945032saunterer
saunterers1044382saunterers
sautes63924912sau_te_s
scunners10357302scunners
scutters103311022scutters
shunners11317742shunners
shunter103611732shunter_
shutters113611352shutters
sinters74024082s_inters
sounders93214112sounders
souters74422602sou_ters
spurters103311702spurters
sputters104012872sputters
squinters1835522squinters
stinters83312752stinters
stunners8277922stunners
stutters83210472stutters
suiters73618882s_uiters
sunders84120052s_unders
taunter73111452taunter_
vaulters11206172vaulters
vaunter10309602vaunter_
wanters104420092wa_nters

Search took 5 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 Filter1786911210590.373479064.3
2DLD Change Limit121059643.64033258.0
3Display Results64640.0164000.0
 (SQL Overall)178691644.02944351.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.