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

306 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
proofers1311836(None) 
proffers16126591proffers
proofer12149101proofer_
roofers105013901_roofers
brooders112610242brooders
crooners103911392crooners
groomers11388482groomers
groovers12337122groovers
hoofers134513332_hoofers
poofters1336922p_oofters
poolers94217422p_oolers
prefers123713332pr_efers
probers113514582pr_obers
prodders1237462prodders
profess1237712pr_ofess
proffer15126932proffer_
proggers12258162proggers
promoters13310092promoters
proofed13138722proofe_d
proofs114511682proof__s
propers113619032pr_opers
proposers13228522proposers
prosers94219642pr_osers
prospers123012262prospers
provers123817792pr_overs
provokers1894202provokers
prowlers13328932prowlers
rolfers104011812_rolfers
roofer94415282_roofer_
roomers95416412_roomers
roosers74217882_roosers
rooters74522932_rooters
spoofers13307322spoofers
troffers14125432troffers
troopers10289442troopers
uprooters1164252uprooters
woofers133810582_woofers
armorers10288973armorers
arousers84810983arousers
bloomers12348823bloomers
bloopers12397373bloopers
boogers104514633_boogers
bookers134016613_bookers
boomers114115913_boomers
boozers183912443_boozers
briefers1335143briefers
broiders114211193broiders
broilers103210093broilers
brokers133111913br_okers
bronzers19296983bronzers
brooder103811623brooder_
brothers133410833brothers
browsers13449203browsers
choosers134810883choosers
coffers154112693_coffers
confers124120093_confers
cooers84324563_coo_ers
cookers134619463_cookers
coolers93522493_coolers
coopers114019483_coopers
cooters94525733_cooters
coroners104016233coroners
croakers14288523croakers
crofters13358913crofters
crooker134111093crooker_
crookery17415993crookery
crooner93714043crooner_
croppers143311483croppers
crosiers103312083crosiers
crossers103912713crossers
crowders14398813crowders
crowers124614903cr_owers
crowners133710753crowners
crozers184111083cr_ozers
croziers19287003croziers
doffers14359853_doffers
doozers17419293_doozers
droners84114383dr_oners
droppers13318603droppers
drovers115212643dr_overs
drowners12428273drowners
feoffers1333133feoffers
flooders12257833flooders
floorers11227573floorers
footers104618333_footers
frothers14279813frothers
frowners14377933frowners
gofers104711513__gofers
goffers14409213_goffers
golfers114410083_golfers
goobers10219623_goobers
groaners9248503groaners
grocers103511253gr_ocers
groomer10399873groomer_
groover11358543groover_
grooves11368803groove_s
gropers104813853gr_opers
grossers94410973grossers
groupers11358643groupers
grousers93810733grousers
grouters95910083grouters
growers113612723gr_owers
growlers12327093growlers
hoofer124014953_hoofer_
hookers144916523_hookers
hoopers123616493_hoopers
hooters104520483_hooters
hoovers134312713_hoovers
ironers74813553ir_oners
loafers10349463_loafers
lookers114014073_lookers
loopers93914033_loopers
looters74419163_looters
mooners94015343_mooners
mooters93818623_mooters
noosers74913933_noosers
offers12349963__offers
pardoners12208213pardoners
parroters1156763parroters
peoplers1237163peoplers
piaffers16114203piaffers
pilfers1238963p_ilfers
pioneers1035863pioneers
plodders1235523plodders
plotters104011553plotters
plovers123611833p_lovers
plowers123812243p_lowers
poisers94214433p_oisers
pokers124617923p__okers
polders103617373p_olders
polers84225643p__olers
pollers93420023p_ollers
ponders103618843p_onders
poofs105222793p_oof__s
poofter1237163p_oofter_
pooler83819843p_ooler_
poorer82613993p_oorer_
pooves113914713p_oove_s
popovers1595663popovers
poppers103414863p_oppers
porkers134314933p_orkers
porters93722703p_orters
posers84223973p__osers
posters93928013p_osters
pothers123818623p_others
potters94024343p_otters
potzers184010543p_otzers
pourers93513673p_ourers
pouters94221873p_outers
powders134111553p_owders
powers113822323p__owers
powters124015663p_owters
praisers103410833praisers
prancers123210333prancers
praters94921653pr_aters
prawners1346003prawners
prayers124212853pr_ayers
preavers13910263preavers
precookers1843063precookers
preeners102712813preeners
prefer113813203pr_efer_
preggers12236833preggers
premiers122911653premiers
preorders1235403preorders
pressers103215023pressers
presters103419003presters
preyers124412363pr_eyers
pricers113915063pr_icers
prickers163710673prickers
priers84521193pr__iers
primers114215673pr_imers
prinkers143010383prinkers
printers103214903printers
prioress1035393prioress
priors83914483prio__rs
prisoners1147373prisoners
prizers183911843pr_izers
prober104516073pr_ober_
probes104119453pr_obe_s
problems1434343problems
proceeds1335983proceeds
process11310403pr_ocess
proctors12311513proctors
procurers1345033procurers
procures1239213procures
prodder1147953prodder_
producers1454883producers
proems104711163pr_o_ems
profaners14256213profaners
proffered1843433proffered
profferer1742933profferer
profferers1842423profferers
profilers14236293profilers
profiters14228313profiters
profits122911243pr_ofits
profs105120893pr_of__s
progger11319373progger_
progress1137023progress
projets1639163pr_ojets
prolegs10379993pr_olegs
proles84627203pr_ole_s
prolongers13264763prolongers
promisers13268203promisers
promodern1444133promodern
promoter12311453promoter_
promotes12314123promote_s
prompters1537553prompters
proof105221533proof___
proofing1439313proofing
proofread1542113proofread
proofreads1651663proofreads
propels113412843pr_opels
proper104319953pr_oper_
prophets1539503prophets
propjets1935493propjets
propones122516963propone_s
proposer121810633proposer_
proposes122515973propose_s
proser84223463pr_oser_
proses84733473pr_ose_s
prosier93817493prosier_
prosper114012193prosper_
prosses94019513prosse_s
proteas92015123pr_oteas
proteus92511593pr_oteus
protoderm1445303protoderm
protoderms1544403protoderms
prouder10310383prouder_
prover113819723pr_over_
proverb14378213pr_overb
proverbs15315583pr_overbs
proves114322253pr_ove_s
providers1535593providers
provoker1784913provoker_
provokes1776603provoke_s
prower114218123pr_ower_
prowess1237903pr_owess
prowler123310013prowler_
proxies163014933proxie_s
pruners93710723pr_uners
pryers115012243pr__yers
puffers15349203p_uffers
reefers103312593_reefers
refers93921083_r_efers
reoffers1434693reoffers
rioters73615523_rioters
roamers93713463_roamers
roarers73812743_roarers
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_r_ogers
rolfer94412273_rolfer_
rollers73117473_rollers
rompers113412243_rompers
roofed105214743_roofe_d
roofies103014413_roofies
roofless11316733_roofless
roofs85321153_roof__s
rookery14398313_rookery
roomer84718633_roomer_
rooser63921883_rooser_
rooses65526243_roose_s
roosters83514673_roosters
rooter64926033_rooter_
ropers84325903_r_opers
rosters73727553_rosters
rotifers1136043_rotifers
rotters74421393_rotters
rousers75220143_rousers
routers74822873_routers
rovers95423523_r_overs
rowers94924573_r_owers
rozzers1535633_rozzers
scoffers16286133scoffers
scoopers124210193scoopers
scooters103511033scooters
shooters112811583shooters
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
sooners73916643_sooners
spoofer12368723spoofer_
spoofery16354313spoofery
spoolers10349363spoolers
stookers12449793stookers
stoopers103711303stoopers
swooners11336863swooners
swoopers13317523swoopers
toolers74416503_toolers
tooters73818773_tooters
troffer13125863troffer_
trollers83211213trollers
trooper94210363trooper_
trotters83310243trotters
troupers10359443troupers
trousers83910633trousers
trovers103713323tr_overs
trowsers11428003trowsers
twofers1364053_twofers
uprooter1085243uprooter_
whoopers16286263whoopers
wolfers13409633_wolfers
wooers93712443_woo_ers
woofer124411363_woofer_
woolers104214023_woolers
wrongers12327773wrongers

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 Limit1461623066.55022314.8
3Display Results3063060.1232487.8
 (SQL Overall)1786913067.09325192.6
 
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.