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

166 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
banterers11241000(None) 
banterer102811771banterer_
barterers11269631barterers
batterers113110711batterers
alterers82512492_alterers
bannerets11205462bannerets
bantered113313632bantere_d
banters94623112bant__ers
barterer102711632barterer_
batteners11238162batteners
batterer102713212batterer_
caterers102814402ca_terers
enterers82214152_enterers
falterers12238032falterers
hankerers16226712hankerers
palterers11249532palterers
panderers12229152panderers
patterers112410122patterers
saunterers1044382saunterers
wanderers13228482wanderers
waterers112312782wa_terers
winterers12209722winterers
adherers1296923_adherers
alterer72714003_alterer_
answerers1243743_answerers
anteaters939343_anteaters
antevert1148993_antevert
anteverts1244723_anteverts
anthers103715203_ant_hers
antlers74014743_ant_lers
antres65021003_ant_re_s
bacterias1349283bacterias
bacterins13410643bacterins
baiters94619303bait__ers
bandagers1335883bandagers
banderols1245953banderols
banders104324563ban__ders
bandores11311603bandore_s
bangers104020353ban__gers
banishers14258053banishers
banisters11189473banisters
bankers133919093ban__kers
bannered11299323bannere_d
banneret102412473bannere_t
bannerols1144093bannerols
banners94018713ban__ners
banqueters2143143banqueters
bantengs1134593bante_ngs
banter84825333bant__er_
bantering122414233bantering
banties94324763bant_ie_s
baptizers2243443baptizers
bartenders1344223bartenders
bartered113113013bartere_d
barters94223033bart__ers
basters94930303bast__ers
batchers153613273ba_tchers
bathers124720363ba_t_hers
battener10369393battener_
battered113315053battere_d
batteries11615113batteries
batters94626013ba_t_ters
battlers104110973ba_ttlers
bickerers17115593bickerers
bitterer10309773bitterer_
blatherers15175343blatherers
blunderers1343943blunderers
blusterers12174993blusterers
bolsterers1244683bolsterers
borderers1276333borderers
bunters94717123bunt__ers
cancelers13247863cancelers
canteens1038573cante_ens
cantered113415983cantere_d
canters94827733cant__ers
caperers122611723ca_perers
capturers1344633capturers
careerers1137243careerers
caterer92815943ca_terer_
cateress102311613ca_teress
charterers15146053charterers
chatterers15205463chatterers
clatterers12155423clatterers
easterners1044823easterners
enterer72015633_enterer_
falterer11239863falterer_
fasteners12237053fasteners
fatteners12236873fatteners
fetterers12267043fetterers
filterers12206973filterers
fingerers13136303fingerers
flatterers13175913flatterers
fosterers12238023fosterers
gatherers13156883gatherers
halteres113414603haltere_s
hammerers16216563hammerers
hamperers16287533hamperers
hankerer15248233hankerer_
hasteners12267813hasteners
hinderers1337353hinderers
integers937783_integers
jabberers2043553jabberers
kanteles1238123kantele_s
lannerets9225483lannerets
lanterns838303lanter_ns
latherers12158853latherers
launderers1183873launderers
letterers9228113letterers
lingerers10126923lingerers
litterers9228193litterers
loiterers936263loiterers
mantelets1176813mantelets
manurers1037593man_urers
maturers1037383ma_turers
maunderers1383753maunderers
meanderers1343803meanderers
miterers10219683_miterers
mutterers11247373mutterers
oysterers1245573oysterers
palterer102411283palterer_
pamperers15236863pamperers
panderer112210913panderer_
pantdress1243363pantdress
panthers13510783pant_hers
paperers122410453pa_perers
parterres1148063parterres
pasturers1136393pasturers
patterer103112173patterer_
pesterers112510463pesterers
pewterers14216043pewterers
plasterers1286123plasterers
ponderers12248453ponderers
potterers11218663potterers
putterers11238363putterers
quarterers19124823quarterers
ranters73323643rant__ers
ratteners9237263ratteners
renderers10208093renderers
santeras8311063santer_as
santerias9311843santerias
santeros8311193santer_os
saunterer945033saunterer_
scatterers12205043scatterers
shatterers13185723shatterers
slanderers1145143slanderers
smatterers12174873smatterers
sneerers8309803_sneerers
sunderers1039073sunderers
tamperers13227313tamperers
taperers10269773ta_perers
tenderers10227803tenderers
tinkerers1395423tinkerers
titterers9236993titterers
totterers9186813totterers
utterers8218653_utterers
veneerers1244523veneerers
venturers1245523venturers
wagerers12247613wa_gerers
wanderer122210123wanderer_
wanters104420093want__ers
wantoners12116673wantoners
waterer103314073wa_terer_
waverers14318613wa_verers
winterer112110443winterer_
wonderers13217933wonderers
yammerers16214453yammerers

Search took 9 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.673265514.1
2DLD Change Limit1486411668.04618473.9
3Display Results1661660.0762184.2
 (SQL Overall)1786911668.79520317.3
 
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.