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

186 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
prompter143798(None) 
promoter12311451promoter
prompted1536901prompted
prompters1537531prompters
orometer10310702orometer
profiter132710202profiter
promiser122510672promiser
promote11313142promote_
promoted13310542promoted
promoters13310072promoters
promotes12314122promotes
prompt12313012prompt__
promptest1546052promptest
promptly1743912promptly
prompts1337472prompt_s
proper104319952pro_p_er
prosper114012182prosp_er
pyrometer1648872pyrometer
romper104213682_romp_er
adopter1036753ado_pter
aerometer11410203aerometer
barometer13189043barometer
biometer1239603biometer
bromate11313553bromate_
bromated1339173bromated
bromates12413133bromates
chomper163810073chomp_er
compeer133811553_compeer
compted143813523_compted
computer144511503_computer
copromoter1644573copromoter
copter109822013_co_pter
crampier14288903crampier
crimper136510423crimp_er
crimpier14287323crimpier
crofter12299573cro_fter
cropper133312963cro_pper
croupier1246883croupier
cryometer1646433cryometer
diopter1038473dio_pter
doomster1135843doomster
droopier1145573droopier
dropper12329873dro_pper
durometer1246443durometer
ergometer1246153ergometer
fronter103611583fro_nter
frumpier1534173frumpier
geometer1138423geometer
groper94517253gro_p_er
grouper104210093group_er
grouter84412523gro_uter
grumpier1334803grumpier
odometer1147413odometer
optometer1347293optometer
orometers11310403orometers
pamper124316663p_amp_er
parameter1349123parameter
pedometer1447723pedometer
peopler1138073peo_pler
perimeter1349543perimeter
peripter1278753peripter
picometer1548913picometer
plotter94113663plo_tter
plumper13318773plump_er
pointer93814933p_ointer
politer92417073p_oliter
poofter1237163p_oofter
popper93615963p_o_pper
porter84224413p_o_rter
poster84129173p_o_ster
potometer1349843potometer
potter83926983p_o_tter
poulter93712013p_oulter
pouter83923983p_o_uter
powter114116033p_o_wter
prater84825353pr__ater
prealter1048863prealter
precomputer1952923precomputer
preempted1644673preempted
preemptor1544153preemptor
premier113515633prem_ier
preppier1156643preppier
prester93519623pr_ester
primate111516283primate_
primates121515933primates
primer105118683prim__er
primmer134310163prim_mer
primped14479153primp_ed
printer93917303pr_inter
privater13158533privater
probate11414483probate_
probated13410863probated
probates12414263probates
prober104516073pro__ber
proctor11310433pro_ctor
procurer1235833procurer
prodder1147953pro_dder
producer1355843producer
proette9312363proette_
proettes10312763proettes
profaner13197943profaner
proffer15126933pro_ffer
profiler13287643profiler
profited14279973profited
profiteer14274493profiteer
profiters14228313profiters
progger11319373pro_gger
prolate9419793prolate_
promine112819443promine_
promines123018803promines
promise113415843promise_
promised133010873promised
promisee122711333promisee
promisers13268203promisers
promises122916763promises
promisor12266183promisor
promodern1444133promodern
promoed12310083prom_oed
prompting1637193prompting
promptness1643293promptness
pronate9418873pronate_
pronated11414053pronated
pronates10418373pronates
pronator10311773pronator
proofer12149103pro_ofer
propel103714063pro_p_el
properer1259203properer
propers113619033pro_p_ers
prophet14316033pro_phet
propjet1839913pro_pjet
propmen1338763pro_pmen
proposer121810633proposer
propped113311953pro_pped
prorate9418733prorate_
prorated11513713prorated
prorates10418063prorates
prosateur1143573prosateur
proser84223463pro__ser
prosier93817483pro_sier
prospers123012253prosp_ers
protea82214763pro__tea
protecter13179103protecter
protei82615303pro__tei
protester111510483protester
prouder10310373pro_uder
prover113819723pro__ver
provider1436703provider
provoker1784913provoker
prower114218123pro__wer
prowler123310013pro_wler
pumper124415553p_ump_er
pyrometers1748323pyrometers
remoter94815973_remoter
roaster74116663_roaster
roister73516203_roister
romped114513653_romp_ed
rompers113412243_romp_ers
rooster74415173_rooster
rooter64926033_ro_oter
roper75431913_ro_p_er
ropier84118803_ro_pier
roster64329083_ro_ster
rotter64325463_ro_tter
roupier9319493_roupier
rouster73517083_rouster
router65025843_ro_uter
royster103110533_royster
spirometer1445763spirometer
stomper114111223stomp_er
sumpter1138873_sumpter
tempter11358213_tempter
tramper113812153tramp_er
trampier12318233trampier
trampler12278003trampler
trimeter10310083trimeter
trompe105611263tromp_e_
tromped124210293tromp_ed
trompes114111623tromp_es
trooper94210353troop_er
trotter73312253tro_tter
trouper93811413troup_er
trumpeter1343153trumpeter
udometer1146333udometer
unprompted1743113unprompted
uprooter1085243upro_oter
vomiter1237953_vomiter

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621869.00016240.2
3Display Results1861860.0762447.4
 (SQL Overall)1786911869.23219355.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.