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

413 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
poofter123716(None) 
poofters1336921poofters
booster94314552booster
cooter85128612coo_ter
crofter12299572crofter
footer94320772foo_ter
goofier11339312goofier
hoofer124014952hoof_er
hooter94123932hoo_ter
lofter94614722_lofter
looter64222322loo_ter
mooter83921092moo_ter
ofter84116872__ofter
plotter94113662plotter
pointer93814932pointer
politer92417072politer
pooftah1543142pooftah
pooler83819842poo_ler
poorer82613992poo_rer
porter84224412p_orter
poster84129172p_oster
potter83926982p_otter
poulter93712012poulter
pouter83923982p_outer
powter114116032p_owter
proffer15126932proffer
profiter132710202profiter
proofer12149102proof_er
roofer94415282roof_er
rooster74415172rooster
rooter64926032roo_ter
softer94015312_softer
spoofer12368722spoof_er
tooter64420802too_ter
woofer124411362woof_er
aborter939933aborter
adopter1036763adopter
after85719793__after
bloater94013423bloater
blotter94612853blotter
boaster94616433boaster
boater84622093_boater
bolster93713423bolster
bolter83920753_bolter
boodler103312003boodler
booger94816553boo_ger
booker124719193boo_ker
boomer104618513boo_mer
boomier113312183boomier
boosted104111983boosted
boosters104013443boosters
booted94822733boo_ted
bootee84323023boo_tee
bootery1238983boo_tery
boozer174815963boo_zer
boozier18349013boozier
clouter93511693clouter
coaster94219043coaster
coater84329573_coater
coffer144112863_coffer
cointer93616723cointer
colter84625093_colter
comfier1439163comfier
confer114018683conf_er
confuter1338513confuter
cooer74831013coo__er
cooker124722453coo_ker
cooler84824713coo_ler
cooper104221123coo_per
coopted123710763coopted
cooters94525723coo_ters
copter109822013_copter
coster84331293_coster
cotter84926673_cotter
coulter94115603coulter
counter94220153counter
courter94516483courter
couter84930223_couter
coveter122912063coveter
crafter124111333crafter
crofters13358903crofters
dafter104813343_dafter
defter104215923_defter
diopter1038473diopter
doffer133911353_doffer
doodler93310153doodler
doomier103610123doomier
doomster1135843doomster
doozer163910463doo_zer
doter65428623_do_ter
dotter74419343_dotter
doubter10298353doubter
drafter11449433drafter
drifter11348703drifter
emoter85415193emo_ter
feoffer1233023feoffer
floater104413353floater
flouter104311343flouter
footed104418623foo_ted
footers104618333foo_ters
footier104115113footier
footler104011873footler
foozler19397593foozler
foster94322223_foster
fronter103611583fronter
gloater83711013gloater
gofer94814283_gof_er
goffer13409513_goffer
goiter74116203_goiter
golfer104411183golf_er
goober93911743goo_ber
goofed114911383goof_ed
gooier73516213goo_ier
goonier83612843goonier
goopier103910573goopier
goosier83512563goosier
grafter114211153grafter
grifter113810493grifter
grouter84412523grouter
hafter124815883_hafter
hefter124313923_hefter
hoister103714203hoister
holster103512213holster
hoodier113812973hoodier
hoofed134614893hoof_ed
hoofers134513333hoof_ers
hooker134820173hoo_ker
hookier143811673hookier
hooper114518313hoo_per
hoopster1335543hoopster
hooted104422663hoo_ted
hooters104520483hoo_ters
hootier104915353hootier
hoover124314433hoo_ver
hotter94720083_hotter
jointer14379713jointer
jolter133513093_jolter
jotter134315633_jotter
jouster143311043jouster
knotter11317643knotter
kookier10398283kookier
lefter93613433_lefter
lifter93814813_lifter
loafer93610943loaf_er
lobster9288853lobster
locater93113603locater
lofted103811893_lofted
lofters103912903_lofters
loftier1037763_loftier
loiter64619173_loiter
looker104816953loo_ker
loonier73312683loonier
looper83817113loo_per
loopier93711193loopier
looser65219943loo_ser
looted74421113loo_ted
looters74419163loo_ters
lotter64025603_lotter
mobster11299213mobster
moister94015373moister
molter84119423_molter
monster93214603monster
moocher143610673moocher
moodier103212203moodier
mooner85317833moo_ner
moonier93714103moonier
moorier93113073moorier
mooted94120373moo_ted
mooters93818623moo_ters
moulter93812423moulter
mounter93713173mounter
nooser65517823noo_ser
noter55025643_no_ter
oater55433733__oater
offer114311383__offer
often84611413__often
oozier153610253_oozier
otter54423973__otter
ouster64223733_ouster
outer55633303__outer
oxter123414093__oxter
oyster94111703_oyster
painter93814563painter
palter84423263p_alter
paster85734373p_aster
pater74740723p__ater
patter84628263p_atter
pearter9412743pearter
pelter83321623p_elter
penster92811953penster
peopler1138083peopler
perter84422283p_erter
pester84827593p_ester
peter74427593p__eter
petter83924773p_etter
pewter114013673p_ewter
phatter123810203phatter
philter12108213philter
phonier122710633phonier
piaffer15104443piaffer
piaster93012883piaster
pilfer1139163pilf_er
pioneer936893pioneer
plaiter93615393plaiter
planter94017803planter
plaster93318693plaster
plater84427693p_later
platter93917413platter
pleater93916333pleater
plodder1146003plodder
plotted104612373plotted
plotters104011553plotters
plottier10327263plottier
plover115312613plo_ver
plower114315063plo_wer
poacher143912323poacher
pocketer16157373pocketer
pockier153911603pockier
podgier11338723podgier
podite93315353podite_
podites103014733podites
pointe84619313pointe_
pointed103813983pointed
pointers103013723pointers
pointes93216753pointes
pointier1038303pointier
poiser84217243p_oiser
poker115122883p_o_ker
pokier124914633p_okier
polder94019253p_older
poler74431793p_o_ler
policer113112683policer
polite83625073polite_
poller83921853p_oller
pollster1037103pollster
polluter1035403polluter
polymer1438063polymer
pomfret1446993pomfret
ponder94521693p_onder
pontes83627853p_ontes
pooched152810083pooched
pooches143214163pooches
poodle93112043poodle_
poodles103013513poodles
pooed85226243poo__ed
poof95541663poof___
poofs105222793poof__s
pooftahs1642363pooftahs
poofy136213273poof__y
poohed123912523poo_hed
pooled94619813poo_led
poolers94217423poo_lers
pooped113915943poo_ped
poor65630223poo___r
poove104514303poo_ve_
pooves113914713poo_ves
popover1495843popover
popper93615963p_opper
porker124917543p_orker
porkier133712343porkier
pornier93413133pornier
ported94223243p_orted
porters93722703p_orters
poser75128773p_o_ser
posher115018163p_osher
posited10511493posited
posted93722493p_osted
postern93615613p_ostern
posters93928013p_osters
pother113818853p_other
potometer1349843potometer
potted94624013p_otted
potters94024343p_otters
pottery123011073p_ottery
pottier93516493pottier
potzer174411213p_otzer
poufed12449713pouf_ed
pouffe14448263pouffe_
pouffed16365953pouffed
pouffes15408123pouffes
poulters103911053poulters
pouncer113511233pouncer
pounder103314003pounder
pourer84516043p_ourer
pouted94021393p_outed
pouters94221873p_outers
poutier93215323poutier
powder123611903p_owder
power105325953p_o_wer
powters124015663p_owters
poxier153812113p_oxier
prater84825353p_rater
prefer113813203pref_er
prester93519623prester
printer93917303printer
prober104516073pro_ber
proctor11310433proctor
prodder1147953prodder
profaner13197943profaner
proffers16126593proffers
profiler13287643profiler
profited14279973profited
profiteer14274493profiteer
profiters14228313profiters
progger11319373progger
promoter12311453promoter
prompter1437983prompter
proofed13138723proof_ed
proofers13118363proof_ers
proper104319953pro_per
proser84223463pro_ser
prosier93817483prosier
prosper114012193prosper
protea82214763pro_tea
protei82615313pro_tei
prouder10310383prouder
prover113819723pro_ver
prower114218123pro_wer
prowler123310013prowler
psalter9247813psalter
puffer144610733p_uffer
puffier1547973puffier
punster92911103punster
punter84320023p_unter
purfler12248733purfler
putter83921443p_utter
quoter153510093quo_ter
rafter94517583_rafter
reoffer1335013reoffer
rioter64817283rio_ter
roaster74116663roaster
roister73516203roister
rolfer94412273rolf_er
roofed105214743roof_ed
roofers105013903roof_ers
roofie93411173roofie_
roofies103014413roofies
rooftop12133253rooftop
rooftree1163353rooftree
rookier114012383rookier
roomer84718633roo_mer
roomier93812243roomier
rooser63921883roo_ser
roosted83211883roosted
roosters83514663roosters
rooted75424003roo_ted
rooters74522933roo_ters
rootier74915393rootier
roster64329083_roster
rotter64325463_rotter
rouster73517083rouster
router65025843_router
royster103110533royster
scoffer15317023scoffer
scooter93312873scooter
scoter83815483sco_ter
scouter93313323scouter
shifter132911083shifter
shooter103013993shooter
shorter103515503shorter
shouter103213083shouter
sifter94516233_sifter
slotter73314453slotter
snifter10349623snifter
snorter74412663snorter
soften9429493_soften
sooner64220463soo_ner
sooted73922593soo_ted
soother104215043soother
sootier73916613sootier
sorter64425093_sorter
souter64225923_souter
spoofed13399103spoof_ed
spoofers13307323spoof_ers
spoofery16354313spoof_ery
spookier14175493spookier
spooler93711383spoo_ler
spoonier10167653spoonier
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
stouter74012053stouter
swifter13318053swifter
swotter10399473swotter
toaster74414463toaster
tooler63818613too_ler
tooted74620123too_ted
tooters73818773too_ters
tootler73511123tootler
toter55932133_to_ter
totter65021463_totter
touter63821033_touter
troffer13125863troffer
trotter73312253trotter
tufter9319933_tufter
twofer1234353twof_er
uplifter1363903uplifter
uprooter1085243uprooter
vomiter1237953vomiter
voter85121053_vo_ter
wafter124114613_wafter
wolfer12429983wolf_er
woodier113912063woodier
wooer84316693woo__er
woofed134511203woof_ed
woofers133810583woof_ers
wooler93615873woo_ler
woolier103612353woolier
woozier19347323woozier
zooier153411233zoo_ier
zoolater1746093zoolater
zootier163611173zootier
zoster153715853_zoster

Search took 10 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274138.43615887.5
3Display Results4134130.1402950.0
 (SQL Overall)1786914138.98219894.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.