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

196 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
promoter1231145(None) 
promote11313141promote_
promoted13310541promoted
promoters13310091promoters
promotes12314121promotes
prompter1437981prompter
copromoter1644572copromoter
orometer10310702orometer
profiter132710202profiter
promiser122510672promiser
promodern1444132promodern
promoed12310082promo_ed
prompted1536902prompted
prompters1537552prompters
proofer12149102pro_ofer
proposer121810632proposer
provoker1784912provoker
pyrometer1648882pyrometer
remoter94815972_remoter
rooter64926032_ro_oter
uprooter1085242upro_oter
aerometer11410203aerometer
armorer9259913ar_morer
barometer13189043barometer
biometer1239603biometer
bromate11313553bromate_
bromated1339173bromated
bromates12413143bromates
brooder103811623bro_oder
broomier1236873broomier
cooter85128613_co_oter
copromoters1753983copromoters
crofter12299573cro_fter
crooker134111093cro_oker
crooner93714043cro_oner
cryometer1646433cryometer
doomster1135843doomster
durometer1246443durometer
emoter85415193__emoter
ergometer1246153ergometer
footer94320773_fo_oter
fronter103611583fro_nter
geometer1138423geometer
groomer10399873gro_omer
groover11358543gro_over
grouter84412523gro_uter
hooter94123933_ho_oter
looter64222323_lo_oter
mooter83921093_mo_oter
odometer1147413odometer
optometer1347293optometer
orometers11310423orometers
parameter1349123parameter
parroter1058203parroter
pedometer1447733pedometer
perimeter1349563perimeter
picometer1548913picometer
plotter94113663plo_tter
pointer93814933p_ointer
politer92417073p_oliter
poofter1237163p_oofter
pooler83819843p_o_oler
poorer82613993p_o_orer
popover1495843p_opover
porter84224413p_o_rter
poster84129173p_o_ster
potometer1349843potometer
potter83926983p_o_tter
poulter93712013p_oulter
pouter83923983p_o_uter
powter114116033p_o_wter
prater84825353pr__ater
prealter1048863prealter
premier113515633prem_ier
premodern1444423premodern
premolar1246633premolar
prester93519623pr_ester
primate111516283primate_
primates121515933primates
primer105118683prim__er
primmer134310163prim_mer
printer93917303pr_inter
prisoner1048573prisoner
privater13158533privater
probate11414483probate_
probated13410863probated
probates12414283probates
prober104516073pr__ober
proctor11310433pro_ctor
procurer1235833procurer
prodder1147953pro_dder
producer1355843producer
proette9312363proette_
proettes10312763proettes
profaner13197943profaner
proffer15126933pro_ffer
profiler13287643profiler
profited14279973profited
profiteer14274493profiteer
profiters14228313profiters
progger11319373pro_gger
prolate9419793prolate_
prologed12189213prologed
prolonger12305873prolonger
promine112819443promine_
promines123018803promines
promise113415843promise_
promised133010873promised
promisee122711333promisee
promisers13268203promisers
promises122916763promises
promisor12266183promisor
promo95620003promo___
promoing13310463promoing
promontory1754483promontory
promos105116423promo__s
promoting1439923promoting
promotion1359503promotion
promotive1648033promotive
prompt12313013prompt__
promptest1546063promptest
promptly1743913promptly
prompts1337473prompt_s
pronate9418873pronate_
pronated11414053pronated
pronates10418373pronates
pronator10311783pronator
pronota939763pronot_a
pronotum1245143pronotum
proofed13138723pro_ofed
proofers13118363pro_ofers
proper104319953pr__oper
properer1259203properer
propone112716303propone_
proponed132412033proponed
propones122516963propones
propose112714843propose_
proposed132011073proposed
proposers13228523proposers
proposes122515973proposes
prorate9418733prorate_
prorated11513713prorated
prorates10418073prorates
prosateur1143583prosateur
proser84223463pr__oser
prosier93817483pro_sier
prosper114012193pro_sper
protea82214763pr__otea
protecter13179103protecter
protei82615313pr__otei
protester111510483protester
protoderm1445303protoderm
protostar1146693protostar
prouder10310383pro_uder
prover113819723pr__over
provider1436703provider
provoke1676123provoke_
provoked1875053provoked
provokers1894203provokers
provokes1776603provokes
prower114218123pr__ower
prowler123310013pro_wler
pulmotor1242813pulmotor
pyrometers1748333pyrometers
remote84222603_remote_
remotes94521613_remotes
remover124612273_remover
rioter64817283_r_ioter
roaster74116663_roaster
roister73516203_roister
romper104213683_rom_per
roofer94415283_ro_ofer
roomer84718633_ro_omer
roomier93812243_roomier
rooser63921883_ro_oser
rooster74415173_rooster
rooted75424003_ro_oted
rooters74522933_ro_oters
rootier74915393_ro_otier
roster64329083_ro_ster
rotter64325463_ro_tter
rouster73517083_rouster
router65025843_ro_uter
royster103110533_royster
scooter93312873sco_oter
shooter103013993sho_oter
spirometer1445763spirometer
tooter64420803_to_oter
trimeter10310083trimeter
trimotor1044813trimotor
trooper94210363tro_oper
trotter73312253tro_tter
udometer1146333udometer
uprooted1186393upro_oted
uprooters1164253upro_oters
vomiter1237953_vomiter

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.406440125.6
2DLD Change Limit1461621967.01620832.7
3Display Results1961960.0762578.9
 (SQL Overall)1786911967.49823831.8
 
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.