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

94 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
saunterer94503(None) 
sauntered1036281sauntered
saunterers1044381saunterers
austerer838382_austerer
banterer102811772ba_nterer
launderer1094512launderer
maunderer1294192maunderer
saunter72913452saunt__er
saunters82911752saunter_s
sputterer11165262sputterer
stutterer9164912stutterer
sunderer9310522s_underer
adulterer1043553adulterer
alterer72713993_a_lterer
auntlier834903_auntlier
austere7312993_austere_
bantered113313633ba_ntered
banterers112410003ba_nterers
barterer102711633ba_rterer
batterer102713213ba_tterer
blunderer1244543blunderer
blusterer11176293blusterer
cantered113415983ca_ntered
caterer92815943ca__terer
chuntered1536663chuntered
countered12313003countered
daundered1294423daundered
daunter83811753daunt__er
daunters9329853daunter_s
enterer72015633__enterer
falterer11239853fa_lterer
flutterer12185263flutterer
fruiterer1243333fruiterer
gaunter82910713gaunt__er
hankerer15248233ha_nkerer
haunter103111153haunt__er
haunters11329543haunter_s
jauntier1535233jaunt_ier
laundered1185023laundered
launderers1183873launderers
maundered1394943maundered
maunderers1383753maunderers
mutterer10218913_mutterer
palterer102411273pa_lterer
panderer112210913pa_nderer
patterer103112173pa_tterer
plunderer1243753plunderer
poulterer1145423poulterer
putterer10209913_putterer
quarterer18145713quarterer
saintlier954623saintlier
santera7311303sa_nter_a
santeras8311063sa_nteras
santeria8311653sa_nteria
santero7311133sa_nter_o
santeros8311193sa_nteros
sauntering1137223sauntering
sauteed8349613sau_te_ed
sauterne846253sau_terne
sauternes947023sau_ternes
scatterer11186293scatterer
scunnered1243803scunnered
scuttered12166423scuttered
shatterer12177203shatterer
shelterer1245033shelterer
shunter103611733shunt__er
shunters113210753shunter_s
shuttered13156333shuttered
sincerer1037203s_incerer
sintered92213903s_intered
slanderer1046673slanderer
slaughterer1552043slaughterer
slenderer1044893slenderer
slumberer13194803slumberer
smatterer11185813smatterer
sneerer73512313s__neerer
splutterer12132743splutterer
sputtered12166323sputtered
sputterers12174583sputterers
squanderer2052153squanderer
stuttered10145763stuttered
stutterers10164303stutterers
sufferer1436063s_ufferer
sundered10312153s_undered
sunderers1039073s_underers
taunter73111453taunt__er
taunters8259273taunter_s
thunderer1344253thunderer
utterer71910463__utterer
vaunter10309603vaunt__er
vaunters11327753vaunter_s
wanderer122210123wa_nderer
waterer103314073wa__terer
winterer112110443_winterer

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.406440125.6
2DLD Change Limit148641946.40623203.4
3Display Results94940.0303133.3
 (SQL Overall)178691946.84226116.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.