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

222 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
prophet1431603(None) 
prophets1539501prophets
propjet1839911propjet
crochet143616662crochet
droplet10312112droplet
poppet92717322p_oppet
projet15315182pro_jet
propel103714062prop_el
proper104319952prop_er
prophecy2043912prophecy
prophesy1844452prophesy
prophetic18710582prophetic
propjets1935492propjets
propmen1338762propmen
propped113311952propped
rochet115423002_rochet
brachet144020313brachet
broche133612103broche_
brocket154013383brocket
brothel12318193brothel
brother123311333brother
crochets15359833crochets
crocket154615673crocket
cropped143812063cropped
cropper133312963cropper
croquet1859683croquet
crotchet152711993crotchet
crownet123714113crownet
drophead1544613drophead
droplets1136063droplets
dropout10410003dropout
dropped13329283dropped
dropper12329873dropper
dropshot1445073dropshot
dropt86924433drop__t
freshet133416643freshet
froglet11310063froglet
frothed14288783frothed
frother133110153frother
gopher1239183_gopher
graphed1498473graphed
grommet12268453grommet
grope84821613grop_e_
groped107515053grop_ed
groper94517253grop_er
gropes95220403grop_es
moppet126915093_moppet
morphed1537133morphed
nymphet1764323nymphet
pamphlet1745733pamphlet
parapet11317643parap_et
paroquet1947283paroquet
people10310193people_
peopled1238503peopled
peopler1138083peopler
peoples11312223peoples
phpht1538063p_hph_t
piolet83225643pio_let
pipet95533323p_ip_et
plopped11288773plopped
pocket144622623p_ocket
poet65552903p_o__et
pooched152810083pooched
pooches143214163pooches
poohed123912523p_oohed
pooped113915943poop_ed
pope85535613p_op_e_
popes95933813p_op_es
popped104117813p_opped
popper93615963p_opper
poppets10338853p_oppets
porches143815673porches
posher115018163p_osher
poshest12312423p_oshest
posset84923253p_osset
pother113818853p_other
preheat12413893pr_eheat
premeet11615153premeet
prepped11329903prepped
prepreg12165963prepreg
preset84430983pr_eset
pricket153616443pricket
prithee1239933prithee
privet113821343pr_ivet
probate11414483probate
probe94320813pro_be_
probed114114823pro_bed
prober104516073pro_ber
probes104119453pro_bes
probit103218353pro_bit
problem1335983problem
proceed12310553proceed
prochein1547523prochein
prodded1257733prodded
prodder1147953prodder
product1279233product
proem94818273pro__em
proette9312363proette
proffer15126933proffer
profit113016273pro_fit
progged12409803progged
progger11319373progger
project1838453project
projets1639163pro_jets
prolate9419793prolate
prole74527793pro_le_
proleg94612113pro_leg
proles84627203pro_les
promoed12310083promoed
promote11313143promote
prompt12313013pro_mpt
prompted1536903prompted
prompter1437983prompter
promptest1546063promptest
pronate9418873pronate
prone75332623pro_ne_
pronged113912393pronged
proofed13138723proofed
proofer12149103proofer
prop85932813prop___
propane112716153propane
propanes122415823propanes
propels113412843propels
propend123311273propend
propene112716043propene
propenes122816513propenes
properer1259203properer
properest1349663properest
propers113619033propers
property1547073property
prophage1649433prophage
prophages1749763prophages
prophase15410243prophase
prophases16411063prophases
prophetess1744243prophetess
propine113020213propine
propined133111503propined
propines122618933propines
propman1339063propman
propone112716303propone
proponed132412033proponed
proponent1349443proponent
propones122516963propones
propose112714843propose
proposed132011073proposed
proposer121810633proposer
proposes122515973proposes
propretor1345533propretor
propria1149933propria
propriety1645433propriety
props95726883prop__s
propyl13358183prop_yl
propyla14296633propyla
propyls14308193propyls
prorate9418733prorate
prose75835123pro_se_
prosect11313393prosect
prosed94921093pro_sed
proser84223463pro_ser
proses84733473pro_ses
prosier93817483prosier
prosiest10416523prosiest
prosit85124593pro_sit
prospect1447893prospect
prosper114012193prosper
prosses94019513prosses
prost75434103pro__st
protea82214763pro_tea
protect11313633protect
protei82615313pro_tei
protest9317533protest
prothetic161010073prothetic
protist9320223protist
prouder10310383prouder
proudest1138943proudest
prove104823193pro_ve_
proved125016033pro_ved
proven114314773pro_ven
prover113819723pro_ver
proves114322253pro_ves
provost1238573provost
prower114218123pro_wer
prowest12311533prowest
prowled13309913prowled
prowler123310013prowler
proxies163014933proxies
prythee1545383prythee
puppet93514593p_uppet
pyrope132810533pyrop_e_
pyropes142210193pyrop_es
rachet115028973_rachet
raphe104916423_raphe_
raphes115117453_raphes
rochets124213473_rochets
rocket125425283_rocket
rope65542913_rop_e_
roped84630803_rop_ed
roper75431913_rop_er
ropes75940063_rop_es
ropey106021873_rop_ey
ropier84118803_ropier
ropiest93317773_ropiest
roquet154415893_roquet
roset55945243_ro_set
roupet84218343_roupet
sprocket1646773sprocket
strophe1239143strophe_
strophes13310603strophes
tophe106718973_tophe_
tophes115218423_tophes
triplet94319213triplet
trippet113714113trippet
troche113112513troche_
trochee122613883trochee
troches123715343troches
trope75725803trop_e_
tropes84824353trop_es
trophic14311033trophic
trophied1437643trophied
trophies13413673trophies
trophy1438283troph_y
trothed114010973trothed

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272227.18618651.1
3Display Results2222220.0802775.0
 (SQL Overall)1786912227.68623248.9
 
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.