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

298 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
sumpters123802(None) 
sumpter1138871sumpter_
bumpers133912052bump_ers
dumpers123412662dump_ers
dumpsters1453742dumpsters
humpers142713522hump_ers
jumpers18399842jump_ers
lumpers113514482lump_ers
mumpers133311372mump_ers
pumpers133113672pump_ers
samplers12299402samplers
scepters1237782scepters
simpers113014122simp_ers
smiters93414362s_miters
stumpers12318312stump_ers
suiters73618882su_iters
summers113616502sum_mers
supers84622402su_p_ers
suppers113314702su_ppers
tempters12257292tempters
adapters1136103adapters
adopters1136693adopters
ammeters1237693ammeters
bumblers143710733bumblers
bummers133712443bum_mers
bumper123714343bump_er_
bumpier13359203bumpier_
bunters94717123bu_nters
bursters1038983bursters
busters94724133bu_sters
butters94521723bu_tters
campers134220293camp_ers
chapters154012133chapters
compeers143410013compeers
computers15339753computers
copters113621283_copters
cumbers134515413cum_bers
cummers133713483cum_mers
cuppers133712213cu_ppers
cutters94218963cu_tters
dampers123915693damp_ers
dempsters1435273dempsters
dimeters11411093dimeters
diopters1137693diopters
dumper114615213dump_er_
dumpier12409653dumpier_
dumpster1344053dumpster_
dupers94615603du_p_ers
dusters84918363du_sters
emoters94712873_emoters
emptiers1275193_emptiers
fumblers15318713fumblers
fumers113613383fum__ers
gulpers10299013gulp_ers
gummers123712203gum_mers
gutters83715513gu_tters
hampers143616953hamp_ers
hamsters13710423hamsters
hemipters1645683hemipters
humates122813193humate_s
humblers15379803humblers
hummers143813063hum_mers
humper134115883hump_er_
humpier143110723humpier_
humpless15226333humpless
hunters103915733hu_nters
hurters103413643hu_rters
imputers1235823_imputers
jumblers19358323jumblers
jumper173612373jump_er_
jumpier18317943jumpier_
justers143815733ju_sters
lampers113817333lamp_ers
lamsters1099753lamsters
limiters10249333limiters
limpers113815223limp_ers
lumbers113815913lum_bers
lumpens11298263lump_ens
lumper103816653lump_er_
lumpier113410143lumpier_
lusters73921443lu_sters
maters85032393__maters
meters85625833__meters
miters84328783__miters
mumblers14328763mumblers
mummers103712843mum_mers
mumper123513523mump_er_
munsters104010553munsters
musters94522513mu_sters
mutters94117143mu_tters
numbers113711243num_bers
nutters74215433nu_tters
ousters74122793ou_sters
outers64230173ou__ters
pampers133615933pamp_ers
plumpers14357293plump_ers
prompters1537553prompters
pulpers114612283pulp_ers
pumicers1434353pumicers
pumper124415553pump_er_
pumpless14236373pumpless
punsters103310583punsters
punters93617043pu_nters
putters94219193pu_tters
quarters173110453quarters
questers17168763questers
quieters17248733quieters
quilters17228433quilters
quippers2184813quippers
quipsters2043593quipsters
quitters17238523quitters
quoters16369263qu_oters
rompers113412243romp_ers
rumblers123610743rumblers
rummers113513653rum_mers
rumples113313133rumple_s
rumpless12256543rumpless
salters73622253s_alters
saluters8319863saluters
samites93118713samite_s
sampler113212013sampler_
samples112815453sample_s
sappers113518903s_appers
saunters82911753saunters
scampers143611033scamp_ers
scamsters1334993scamsters
scatters103612753scatters
scepter1138353scepter_
sceptres1244993sceptres
scimiters1345123scimiters
scooters103511033scooters
scoters93313813s_coters
scouters103411323scouters
scripters13116673scripters
sculptors1343993sculptors
scummers14277783scum_mers
scuppers1446543scuppers
scutters103311023scutters
seamsters1136333seamsters
seaters74028943s_eaters
semesters1139123semesters
septets998953s_eptets
setters73822063s_etters
shapers124016893shap_ers
shatters113313913shatters
sheeters113111863sheeters
shelters113412813shelters
shifters14319863shifters
shippers153012313shippers
shooters112811583shooters
shoppers153010763shoppers
shouters113510623shouters
shunters113210753shunters
shutters113611353shutters
shysters14106463shysters
sifters103714793s_ifters
sighters122510603sighters
simitars1046483simitars
simmers113314613sim_mers
simper103616293simp_er_
simperers1335933simperers
simpler112910863simpler_
simples113014943simple_s
sinters74024083s_inters
sippers113117753s_ippers
sisters73721593s_isters
sitters74221553s_itters
skaters113512963s_katers
skeeters12298963skeeters
skelters12349373skelters
skippers16318203skippers
skirters12337243skirters
skitters12349553skitters
slappers123710943slappers
slaters73123733s_laters
slippers123711233slippers
slitters84014133slitters
slopers94213093slop_ers
slotters84012403slotters
slumbers123110273slum_bers
slummers12358933slum_mers
smatters104011713smatters
smelters103310513smelters
smilers94113853s_milers
smiter83616413s_miter_
smites83921923s_mite_s
smithers13369793s_mithers
smokers13389323s_mokers
smothers13349933s_mothers
snappers123510173snappers
snifters11318613snifters
snipers93311773snip_ers
snippers12299723snippers
snorters83410583snorters
soapers93715923soap_ers
somites94219123somite_s
sorters74221133s_orters
souters74422603s_outers
spatters103914703spatters
specters122811063specters
speers85019953s__peers
spelters103912243spelters
spiers84421743s__piers
spitters104113383spitters
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
spurters103311703spurters
sputters104012873sputters
squatters1834943squatters
squinters1835523squinters
squirters1835073squirters
stampers124211603stamp_ers
staplers103111203staplers
starters83714773starters
staters73922343s_taters
steppers12289283steppers
stinters83312753stinters
stompers123610043stomp_ers
stopers94217373stop_ers
stoppers123910593stoppers
stumblers1334383stumblers
stumper113610093stump_er_
stumpier1255883stumpier_
stutters83210473stutters
subduers1186363subduers
subers85722643su__bers
subitems1245493subitems
submitters1444443submitters
suckers133717623su_ckers
sucklers14379963sucklers
sudsers83310423su_dsers
suers55128483su___ers
suffers133113543su_ffers
sugarers936303sugarers
suiter64121813su_iter_
suites63727403su_ite_s
suitors73012493su_itors
sulkers113613343su_lkers
sulphurs1383653sulphurs
sumless92611123sum_less
summates122610493summate_s
summer104017713sum_mer_
summery14329413sum_mery
summiteers1442343summiteers
summoners1344733summoners
sumps95023433sump___s
sumptuary1651693sumptuary
sumptuous1343073sumptuous
sumpweed1643723sumpweed
sumpweeds1742353sumpweeds
sunders84120053su_nders
super74924483su_p_er_
superb104410993su_p_erb
supes75628303su_p_e_s
supper104115433su_pper_
suppler1148433suppler_
supples11511283supple_s
suppliers1354483suppliers
supporters1444093supporters
supposers1344533supposers
suppress1236443suppress
surfers103614133su_rfers
surgers83517483su_rgers
surmisers1145203surmisers
suspires1038203suspires
sutlers73116973su_tlers
suttees74114063su_ttees
swampers15317473swamp_ers
swappers15358083swappers
swatters113911793swatters
sweaters113811063sweaters
swelters113110193swelters
swifters14277483swifters
swotters11448483swotters
symptoms1743753symptoms
syphers15317273s_yphers
tampers113516743tamp_ers
tempers113513013temp_ers
tempter11358213tempter_
thumpers15365713thump_ers
trumpeters1442633trumpeters
tufters10298353tu_fters
tumblers123110623tumblers
tummlers12295703tummlers
ulsters72711983_ulsters
umbers104215213_um_bers
umpires1137813_umpires
umpteen1143843_umpteen
uniters73814173_uniters
unmiters1037073unmiters
uppers102912293_u_ppers
uptears9106453_u_ptears
ureters7311823_ureters
usurpers1033743usurp_ers
utters63817123_u_tters
vampers143111623vamp_ers
vomiters1337203vomiters

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622986.42322756.0
3Display Results2982980.1102709.1
 (SQL Overall)1786912986.68926714.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.