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 “rapt” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

275 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
rapt6724531(None) 
apt57352541_apt
raft76245911raft
rant45864681rant
rap56261961rap_
rape65041631rape
raps66247731raps
rat37892741ra_t
trapt76433391trapt
wrapt105123181wrapt
act59557842_act
adapt81218552adapt
aft66849012_aft
ait38093902_ait
alt36467962_alt
ant37270792_ant
ape57251182_ape
apo511142122_apo
app76827602_app
art38679142_art
at212393402_a_t
att35454652_att
baht96740012baht
bait66556002bait
bap76455842bap_
baps86040842baps
bast66362412bast
bat510988952ba_t
batt65053872batt
bract96332722bract
brant74742172brant
brat66055542bra_t
cant66362032cant
cap76758982cap_
cape87242782cape
caph116623292caph
capo85829212capo
caps87147892caps
caput9823982caput
cart66570342cart
cast67159902cast
cat58282342ca_t
chapt125827642chapt
clapt98027172clapt
coapt96131532coapt
craft105327662craft
crap85731842crap_
crape96128442crape
craps95328642craps
crept95125892crept
crypt123715232crypt
daft85537252daft
dap66652452dap_
daps77239162daps
dart55857872dart
daut56443562daut
dawt85435942dawt
dipt77339322dipt
draft95526682draft
drape85319632drape
drat56247832dra_t
dript86923872dript
dropt86924432dropt
east46659102east
eat36989052ea_t
enrapt8313012enrapt
erupt74220062erupt
fact97142542fact
fart76860562fart
fast77052312fast
fat68178082fa_t
frap95925812frap_
fraps105620552fraps
frat75648542fra_t
gait56150192gait
gap67055612gap_
gape75134512gape
gaps76042972gaps
gapy106320912gapy
gast56052562gast
gat46880512ga_t
graft95327202graft
grant64840022grant
grape84824662grape
graph115315612graph
grapy115416432grapy
grat55651282gra_t
gript85126172gript
haet75659502haet
haft105941842haft
halt76056302halt
hant75461592hant
hap87360052hap_
haps96443462haps
hart76865772hart
hast76259482hast
hat67289962ha_t
haut75949732haut
inapt73522692inapt
jape134923422jape
kapa106021292kapa
kaph135815752kaph
kaput11717062kaput
kart86750802kart
kat77468292ka_t
kept106232942kept
kraft125721012kraft
krait94726772krait
kraut95221402kraut
lap58565272lap_
laps66848872laps
last46260322last
lat37593402la_t
leapt75027472leapt
lept66440882lept
malt66254812malt
map77255122map_
maps86141052maps
mart66865982mart
mast65959962mast
mat58083942ma_t
matt65752662matt
maut65448452maut
nap56753202nap_
napa66927262napa
nape65230802nape
naps66238582naps
oast47156322oast
oat39888262oa_t
opt57545542_opt
pact86648722pact
pant66061262pant
pap76758402pap_
papa85827142papa
paps86443452paps
part65967462part
past65959012past
pat58089462pa_t
prat65952042pra_t
qat125253332qa_t
rabat72832222rabat
race66746262race
rack106234882rack
racy95825682racy
rad47662002ra_d
rads56046602rads
raff104933042raff
rafts87820632rafts
rag45761322ra_g
raga55930812raga
rage55742352rage
ragg65622692ragg
ragi56032282ragi
rags55448372rags
rah68052402ra_h
rai37658222ra_i
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rais45252622rais
raita54623072raita
raj105740222ra_j
raja117918682raja
rake84841572rake
raki87127832raki
raku85423772raku
rale45050562rale
ralph1078742ralph
ram56867272ra_m
ramet75743142ramet
rami66034092rami
ramp85934002ramp
ramps96224632ramps
rams65950772rams
ran38266622ra_n
rand55839572rand
rang56939162rang
rani46640112rani
rank85135532rank
rants55935342rants
raped85334622raped
raper74932752raper
rapes75740722rapes
raphe104916422raphe
rapid86422032rapid
rapist82520672rapist
raptly11338912raptly
raptor83912822raptor
rare45348432rare
ras37575392ra_s
rase46149982rase
rash76039932rash
rasp66029162rasp
rasps74316662rasps
raspy106511702raspy
rate45458762rate
rath76037662rath
rato45436972rato
rats46260372rats
ratty84819592ratty
rave75542092rave
raw67252252ra_w
raws75238212raws
rax108445722ra_x
ray66361992ra_y
raya75224822raya
rays77642352rays
raze135235432raze
razz125219422razz
react74634332react
reap65934742reap_
reaps75626192reaps
reft75141272reft
rent46661242rent
rep55847802rep_
repo66027542repo
repot75132622repot
repp85418742repp
reps65937952reps
rest46459842rest
ret35982832r_et
riant55833152riant
rift75642332rift
riot45947212riot
rip56851302rip_
ripe66038922ripe
rips66237432rips
roast56230142roast
root45655922root
rope65542912rope
ropy96323412ropy
rot37282952r_ot
rout46153282rout
runt46647992runt
rust45544912rust
rut35560522r_ut
ryot75528562ryot
salt45758522salt
sap56463232sap_
saps65346372saps
sat36288482sa_t
sept65844362sept
spat66548522spat
tact67349032tact
tap57663872tap_
tapa65129142tapa
tape64538142tape
taps66050672taps
tart47566182tart
tat37690292ta_t
taut47048962taut
tract75635712tract
trait56940842trait
trap67532802trap_
traps75727482traps
unapt710421592unapt
vast75045122vast
vat67863452va_t
waft106139002waft
wait75553692wait
want76156172want
wap86553372wap_
waps96642082waps
wart77866082wart
wast75655852wast
wat67378922wa_t
watt75545412watt
wept95635052wept
wrap96821972wrap_
wraps105617152wraps
yap85949822yap_
yaps95933522yaps
zap145840692zap_
zaps156826892zaps

Search took 2 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 Filter178691298720.313570897.8
2DLD Change Limit298722750.90632971.3
3Display Results2752750.0604583.3
 (SQL Overall)1786912751.279139711.5
 
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.