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

346 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
prompt1231301(None) 
prompts1337471prompts
compt116328222_compt
dropt86924432dro_pt
pomp106225462p_omp_
pomps115316192p_omps
preempt1337722preempt
primp115615922primp_
primps124711822primps
probit103218352probit
profit113016272profit
projet15315182projet
prom87631702prom__
promo95620002prom_o
promos105116422promos
promote11313142promote
prompted1536902prompted
prompter1437982prompter
promptly1743912promptly
proms95426412prom_s
prop85932812pro_p_
props95726882pro_ps
prosit85124592prosit
prost75434102pro_st
romp85926572_romp_
romps94617542_romps
tromp95815802tromp_
trompe105611262trompe
tromps104911702tromps
adopt81219743ado_pt
armet76739453ar_met
armpit10811093ar_mpit
aroint6328153aroint
aroma71220143arom_a
aromas81018613aromas
aroynt9312893aroynt
bromal10313653bromal
bromate11313553bromate
brome94421973brom_e
bromes104719763bromes
bromic122412693bromic
bromid112612893bromid
bromin102615693bromin
bromo95217203brom_o
bromos104213313bromos
chomp144815663chomp_
chomps155112223chomps
clomp115615703clomp_
clomps125212233clomps
coapt96131533_coapt
coempt12311033coempt
comet95946073_comet
comp106731253_comp_
compo115318573_compo
comps115526053_comps
compts125216653_compts
coopt95929853_coopt
cramp115120693cramp_
crampit1338863crampit
cramps125615563cramps
crampy154710993crampy
crept95125893cr_ept
crimp115615803crimp_
crimps124613453crimps
crimpy15489393crimpy
croft105622683cro_ft
crop87628633cro_p_
crops96125233cro_ps
croup95616783croup_
croupe105114433croupe
croups104312553croups
croupy13458733croupy
crump115616423crump_
crumpet133711063crumpet
crumps124514343crumps
crypt123715233cr_ypt
dript86923873dr_ipt
droit65127123dro_it
dromon939363dromon
droop85814823droop_
droops95110963droops
droopy12458243droopy
drop75324403dro_p_
drops85719503dro_ps
erupt74220063er_upt
exempt1737453exempt
format113021353format
from96923923from__
front85029223fro_nt
frost84727833fro_st
frowst125512073frowst
frump126912563frump_
frumps13479783frumps
frumpy16466883frumpy
gramp106218323gramp_
grampa115010173grampa
gramps114114273gramps
gript85126173gr_ipt
groat65531973gro_at
grommet12268453grommet
grope84821613gro_pe
grot55942053gro__t
group85413923group_
groups94210513groups
grout65330423gro_ut
grump105115313grump_
grumps114510573grumps
grumpy14498153grumpy
impromptu1791773impromptu
irrupt846993irrupt
kempt134318463_kempt
omit65337373__omit
oomph1236973_oomph
opt57545543__o_pt
pampa114913423p_ampa
pelmet103419243pelmet
percept133112523percept
periapt11313413periapt
permit10321683permit
phot95534363pho__t
pimp106024903p_imp_
pimps114616983p_imps
piolet83225643piolet
plop86625743plo_p_
plops95920333plo_ps
plot66141233plo__t
plump115315263plump_
plumps124612613plumps
poet65552903p_o_et
point75338733p_oint
pom78249913p_om__
pome85636693p_om_e
pomes94833933p_omes
pommy14449863p_ommy
pomo85828453p_om_o
pomos95321583p_omos
pompom1436493p_ompom
pompon1238943p_ompon
poms87037743p_om_s
poop86532813p_oop_
poops94422413p_oops
pop76252253p_o_p_
pope85535613p_o_pe
poppa8409893p_oppa
poppet92717323p_oppet
poppy114813193p_oppy
pops86340953p_o_ps
port66059633p_o_rt
posit75833333p_osit
post67953363p_o_st
pot58078433p_o__t
poult76928873p_oult
pout65752553p_o_ut
pram85733493pram__
prams96125513pram_s
prat65952043pr__at
preact103220393preact
preamp1238993preamp_
preamps1336613preamps
precept133112513precept
precut102016533precut
preempts1444543preempts
preman104117453preman
premed114617753premed
premeet11615153premeet
premen105017803premen
premie103617993premie
premix173710333premix
premixt183510663premixt
premolt11312073premolt
preop94715873preop_
preops104911943preops
prep86427673pr_ep_
preppy1235523preppy
preps96220693pr_eps
preset84430983preset
prest75736353pr_est
priapi1037923priapi
priest84125423priest
prim85132203prim__
prima95019343prim_a
primal104014623primal
primas104418103primas
primate111516283primate
prime96525603prim_e
primed115118913primed
primer105118683primer
primes104225263primes
primi95017403prim_i
primly13439623primly
primo95017913prim_o
primos104514423primos
primped14479153primped
prims95425933prim_s
primus103712173primus
print74837463pr_int
privet113821343privet
pro55837263pro___
proa66229963pro__a
proas75028803pro_as
probate11414483probate
probe94320813pro_be
probed114114823probed
prober104516073prober
probes104119453probes
probits112712573probits
probity14299683probity
prod76129503pro__d
prods85523553pro_ds
product1279233product
proem94818273pro_em
proems104711163proems
proette9312363proette
prof96134663pro__f
profits122911243profits
profs105120893pro_fs
prog75729003pro__g
progs86624153pro_gs
progun968783progun
project1838453project
projets1639163projets
prolan8414693prolan
prolate9419793prolate
prole74527793pro_le
proleg94612113proleg
proles84627203proles
prolix1538683prolix
prolog94212973prolog
promine112819443promine
promise113415843promise
promoed12310083promoed
promoted13310543promoted
promoter12311453promoter
promotes12314123promotes
prompters1537553prompters
promptest1546063promptest
prompting1637193prompting
pronate9418873pronate
prone75332623pro_ne
prong85218113pro_ng
prongs94314483prongs
pronota939763pronota
pronto8313993pronto
proof105221533pro_of
proofs114511683proofs
propel103714063propel
proper104319953proper
prophet14316033prophet
propjet1839913propjet
propman1339063propman
propmen1338763propmen
propped113311953propped
propyl13358183propyl
prorate9418733prorate
pros65742783pro__s
prose75835123pro_se
prosect11313393prosect
prosed94921093prosed
proser84223463proser
proses84733473proses
proso77222413pro_so
prosos85718553prosos
prospect1447893prospect
prosper114012193prosper
pross76529403pro_ss
prosy106319253pro_sy
protea82214763protea
protect11313633protect
protei82615313protei
protest9317533protest
protist9320223protist
proton84318893proton
protyl11308213protyl
proud84615483pro_ud
prove104823193pro_ve
proved125016033proved
proven114314773proven
prover113819723prover
proves114322253proves
provost1238573provost
prow97030383pro__w
prowar114110943prowar
prower114218123prower
prowest12311533prowest
prowl105615123pro_wl
prowls115511083prowls
prows106327013pro_ws
proxy175011013pro_xy
prutot8311823prutot
pump105726853p_ump_
pumps115520603p_umps
pyrope132810533pyro_pe
ramet75743143_ramet
ramp85934003_ramp_
ramps96224633_ramps
rapt67245313_r_apt
remet74843723_remet
remit75737223_remit
roast56230143_roast
robot7325973_robot
rom59855633_rom__
roman75424823_roman
romeo73719703_romeo
romped114513653_romped
romper104213683_romper
roms67038963_rom_s
roost55730933_roost
root45655923_ro_ot
rope65542913_ro_pe
ropy96323413_ro_py
roset55945243_roset
rot37282953_ro__t
roup66627693_roup_
roupet84218343_roupet
roups75118903_roups
roupy106112713_roupy
roust55532063_roust
rout46153283_ro_ut
rump86729083_rump_
rumps95922293_rumps
sprout8419403spro_ut
stomp95616663stomp_
stomps105612833stomps
stopt76528353sto_pt
tempt95124843_tempt
tramp96319773tramp_
tramps105114453tramps
trampy13499253trampy
trapt76433393tr_apt
tromped124210293tromped
trompes114111623trompes
troop76417533troop_
troops85712783troops
trop66833303tro_p_
trope75725803tro_pe
trot46351313tro__t
troupe84812433troupe
trout57332573tro_ut
trump95615123trump_
trumpet113810723trumpet
trumps104611883trumps
uproot8314123upro_ot
vomit102622573_vomit
whomp155011323whomp_
whomps16457603whomps
wrapt105123183wr_apt

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127163465.42320784.8
3Display Results3463460.1103145.5
 (SQL Overall)1786913465.65631593.2
 
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.