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

317 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
poofters133692(None) 
poofter1237161poofter_
boosters104013442boosters
cooters94525722coo_ters
crofters13358902crofters
footers104618332foo_ters
hoofers134513322hoof_ers
hooters104520472hoo_ters
lofters103912902_lofters
looters74419162loo_ters
mooters93818622moo_ters
plotters104011552plotters
pointers103013722pointers
pooftahs1642362pooftahs
poolers94217422poo_lers
porters93722702p_orters
posters93928012p_osters
potters94024342p_otters
poulters103911052poulters
pouters94221872p_outers
powters124015662p_owters
proffers16126592proffers
profiters14228312profiters
proofers13118362proof_ers
roofers105013902roof_ers
roosters83514662roosters
rooters74522932roo_ters
spoofers13307322spoof_ers
tooters73818772too_ters
woofers133810582woof_ers
aborters1038573aborters
adopters1136693adopters
afters94717073__afters
bloaters103311023bloaters
blotters104110983blotters
boasters103915663boasters
boaters93419243_boaters
bolsters103712453bolsters
bolters94017803_bolters
boodlers113710743boodlers
boogers104514633boo_gers
bookers134016613boo_kers
boomers114115913boo_mers
booster94314553booster_
bootees94114473boo_tees
bootery1238983boo_tery
boozers183912443boo_zers
clouters10399803clouters
coasters104317333coasters
coaters93525793_coaters
coffers154112693_coffers
cointers103616413cointers
colters93522443_colters
confers124120093conf_ers
confuters1437793confuters
cooers84324563coo__ers
cookers134619463coo_kers
coolers93522493coo_lers
coopers114019483coo_pers
cooter85128613coo_ter_
copters113621283_copters
costers94128333_costers
cotters94323443_cotters
coulters103614313coulters
counters103320193counters
courters103015373courters
couters93827303_couters
coveters132411083coveters
crafters13419953crafters
crofter12299573crofter_
diopters1137693diopters
doffers14359853_doffers
doodlers10338843doodlers
doomsters1236173doomsters
doozers17419293doo_zers
doters74423913_do_ters
dotters83715973_dotters
doubters11257393doubters
drafters12338523drafters
drifters12417913drifters
emoters94712873emo_ters
feoffers1333133feoffers
floaters112711513floaters
flouters11419273flouters
footer94320773foo_ter_
footlers113910793footlers
foozlers20346073foozlers
fosters104220103_fosters
gloaters9288863gloaters
gofers104711513_gof_ers
goffers14409213_goffers
goiters84014443_goiters
golfers114410083golf_ers
goobers10219623goo_bers
goofier11339313goofier_
grafters12409193grafters
grifters12389233grifters
grouters95910083grouters
hafters134614333_hafters
hefters134312003_hefters
hoisters113513483hoisters
holsters113211943holsters
hoofer124014953hoof_er_
hoofless14258013hoofless
hookers144916513hoo_kers
hoopers123616483hoo_pers
hoopsters1445693hoopsters
hooter94123933hoo_ter_
hoovers134312703hoo_vers
jointers15289323jointers
jolters143711993_jolters
jotters143413803_jotters
jousters153210423jousters
knotters12276153knotters
lifters104313783_lifters
loafers10349463loaf_ers
lobsters10268743lobsters
locaters102710073locaters
lofter94614723_lofter_
loiters74116613_loiters
lookers114014073loo_kers
loopers93914033loo_pers
looter64222323loo_ter_
lotters73921063_lotters
mobsters12359063mobsters
molters93816973_molters
monsters103314553monsters
moochers15369123moochers
mooners94015343moo_ners
mooter83921093moo_ter_
moulters103510783moulters
mounters103712503mounters
noosers74913923noo_sers
noters64021003_no_ters
oaters65029793__oaters
offers12349963__offers
ofter84116873__ofter_
otters64021513__otters
ousters74122793_ousters
outers64230173__outers
oxters134813273__oxters
oysters103411693_oysters
painters103013023painters
palters94021683p_alters
pasters94531733p_asters
paters84935833p__aters
patters94825193p_atters
pelters93720313p_elters
pensters103012123pensters
peoplers1237163peoplers
pesters93827093p_esters
peters86624593p__eters
petters93722363p_etters
pewters124113353p_ewters
philters1398173philters
piaffers16114203piaffers
piasters102912813piasters
pilfers1238963pilf_ers
pioneers1035863pioneers
plaiters103512633plaiters
planters102915323planters
plasters103518133plasters
platers93924093p_laters
platters103415283platters
pleaters103613793pleaters
plodders1235523plodders
plotter94113663plotter_
plovers123611833plo_vers
plowers123812243plo_wers
poachers152910763poachers
pocketers17196493pocketers
podites103014733podite_s
poetess938933p_oetess
pointer93814933pointer_
pointes93216753pointe_s
poisers94214433p_oisers
pokers124617923p_o_kers
polders103617373p_olders
polers84225643p_o_lers
policers12259993policers
politer92417073politer_
pollers93420023p_ollers
pollsters1137173pollsters
polluters1135033polluters
polymers1538333polymers
pomfrets1543033pomfrets
ponders103618843p_onders
pontes83627853p_onte_s
pooches143214163pooche_s
poodles103013513poodle_s
poofs105222793poof___s
pooftah1543143pooft_ah
pooler83819843poo_ler_
poorer82613993poo_rer_
poorness1036363poorness
pooves113914713poo_ve_s
popovers1595663popovers
poppers103414863p_oppers
porkers134314933p_orkers
porter84224413p_orter_
posers84223973p_o_sers
poster84129173p_oster_
postern93615613p_ostern
posterns102713723p_osterns
pothers123818623p_others
potometers1449063potometers
potter83926983p_otter_
pottery123011073p_ottery
potzers184010543p_otzers
pouffes15408123pouffe_s
poulter93712013poulter_
pouncers12349203pouncers
pounders113113283pounders
pourers93513673p_ourers
pouter83923983p_outer_
powders134111553p_owders
powers113822323p_o_wers
powter114116033p_owter_
praters94921653p_raters
prefers123713333pref_ers
presters103419003presters
printers103214903printers
probers113514583pro_bers
proctors12311513proctors
prodders1237463prodders
profaners14256213profaners
profess1237713prof_ess
proffer15126933proffer_
profilers14236293profilers
profiteers15213693profiteers
profiter132710203profiter_
proggers12258163proggers
promoters13310093promoters
prompters1537553prompters
proofer12149103proof_er_
propers113619033pro_pers
prosers94219643pro_sers
prospers123012263prospers
proteas92015123pro_teas
proteus92511593pro_teus
provers123817793pro_vers
prowlers13328933prowlers
psalters10227713psalters
puffers15349203p_uffers
punsters103310583punsters
punters93617043p_unters
purflers13216963purflers
putters94219193p_utters
quoters16369263quo_ters
rafters103715633_rafters
reoffers1434693reoffers
rioters73615513rio_ters
roasters83615933roasters
roisters83615553roisters
rolfers104011813rolf_ers
roofer94415283roof_er_
roofies103014413roofie_s
roofless11316733roofless
rooftops13152913rooftops
rooftree1163353rooftree
rooftrees1242403rooftrees
roomers95416413roo_mers
roosers74217873roo_sers
rooster74415173rooster_
rooter64926033roo_ter_
rosters73727543_rosters
rotters74421393_rotters
rousters84315683rousters
routers74822873_routers
roysters113610533roysters
scoffers16286133scoffers
scooters103511033scooters
scoters93313813sco_ters
scouters103411323scouters
shifters14319863shifters
shooters112811583shooters
shouters113510623shouters
sifters103714793_sifters
slotters84012403slotters
snifters11318613snifters
snorters83410583snorters
softens10347623_softens
softer94015313_softer_
sooners73916643soo_ners
soothers113913433soothers
sorters74221133_sorters
souters74422603_souters
spoofer12368723spoof_er_
spoofery16354313spoof_ery
spoolers10349363spoo_lers
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
swifters14277483swifters
swotters11448483swotters
toasters83912723toasters
toolers74416503too_lers
tooter64420803too_ter_
tootlers8289503tootlers
toters65026363_to_ters
totters74618733_totters
touters74018353_touters
troffers14125433troffers
trotters83310243trotters
tufters10298353_tufters
twofers1364053twof_ers
uplifters1463283uplifters
uprooters1164253uprooters
vomiters1337203vomiters
voters95017443_vo_ters
wafters134112813_wafters
wolfers13409633wolf_ers
wooers93712443woo__ers
woofer124411363woof_er_
woolers104214023woo_lers
zoolaters1844983zoolaters
zosters163015413_zosters

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.420425454.8
2DLD Change Limit1461623176.70321805.5
3Display Results3173170.1102881.8
 (SQL Overall)1786913177.23324705.0
 
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.