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

314 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
raphae11431173(None) 
raphe104916421raph_e
rhaphae1543191rhaphae
daphne12237012daphne
hyphae1746432hyphae
rape65041632rap__e
raphes115117452raphes
raphia113511262raphia
raphias123511082raphias
raphide13138072raphide
raphis114014322raphis
rapine85023082rapine
rappee103618672rappee
rathe85821922rath_e
rhaphe1433422rhaph_e
ache96829823_ach_e
agapae9388043agap_ae
agha87417303_agha_
aghas97014873_aghas
agrapha1345133agrapha_
aha611246643_a_ha_
alae45643753_a_lae
algae65319623_algae
alpha1049653alpha_
alphas1139513alphas
anaphase1345463anaphase
ansae55720973_ansae
antae56828293_antae
apace94718383_apace
ape57251183_ap__e
apeak115513453_apeak
aphid115515393_aphid
aphis105917133_aphis
aphthae1544703_aphthae
apian75018333_apian
apnea73413413_apnea
appal95315223_appal
apple94517673_apple
apse67725383_ap_se
aquae142212713_aquae
archaea12137613archaea
areae55229743_areae
arhat8327093_arhat
aurae54128113_aurae
baccae12119703baccae
bashaw14349303bashaw
bathe105822883bath_e
cache125122483cach_e
cape87242783cap__e
caph116623293caph__
caphs124515373caph_s
capias10318353capias
capote10315733capote
captan101613343captan
cashaw14439793cashaw
crape96128443crap__e
crappie13298983crappie
dacha114812573dacha_
dachas124113253dachas
daphnes13327683daphnes
dapple1138853dapple
diphase1387273diphase
drachmae1643933drachmae
drape85319633drap__e
epha9310053_epha_
ephah1337063_ephah
ephas10311543_ephas
faciae112913413faciae
faunae95210373faunae
frappe13286953frap_pe
galeae74717453galeae
gape75134513gap__e
graham1237853gra_ham
grape84824663grap__e
graph115315613graph__
graphed1498473graphed
grapheme1644013grapheme
graphic1537353graphic
graphite1447153graphite
graphs124510153graph_s
grappa11396443grappa_
grappas12357103grappas
grapple12378003grapple
hae67364003___hae
haha107821063ha_ha_
hahas117118443ha_has
hapax1739323hap_ax
hypha1637383hypha_
hyphal1736413hyphal
imphee13310353imphee
inphase1245383inphase
japan14411233jap_an
jape134923423jap__e
kapa106021293kap_a_
kapas116021733kap_as
kaph135815753kaph__
kaphs144911503kaph_s
kappa13469743kappa_
kappas144410363kappas
kasha124710723kasha_
kashas133311903kashas
lahar83114263la_har
lamiae84817453lamiae
lapse74917683lap_se
larvae938843larvae
lathe85626713lath_e
laurae64011663laurae
mache125925303mach_e
mahoe10315573ma_hoe
mammae94613213mammae
maple95521143map_le
mashie11315933mashie
mayhap1635233mayhap
nachas114914193nachas
napa66927263nap_a_
napas75924353nap_as
nape65230803nap__e
nappa98511863nappa_
nappas105511613nappas
nappe96114993nap_pe
nappie104112263nappie
nuchae11218513nuchae
nymphae1743833nymphae
orache114013593orach_e
orphan1137733orphan
ouphe104413263ouph_e
pacha126518063pacha_
pachas135017143pachas
paleae84820293paleae
papa85827143pap_a_
papal95820673pap_al
papas94927493pap_as
papaw125112493pap_aw
paphian1437453paphian
papulae11249353papulae
papule102212133papule
parae76335703pa_rae
pasha105417183pasha_
pashas115117063pashas
phage115113673__phage
phase104617213__phase
phat95837863__phat
prophage1649433prophage
prophase15410243prophase
pupae96515643pup_ae
rabat72832223ra_bat
rabble103818243rabble
race66746263ra__ce
raceme1039733raceme
rachet115028973rachet
rachial122012173rachial
rachis114017653rachis
racial83419243racial
rackle123917293rackle
radar61316723ra_dar
raddle84816173raddle
radial74020393radial
radiale83813523radiale
radian74117273radian
radiate83416313radiate
radome9511873radome
radulae837963radulae
raffle123910703raffle
raga55930813ra_ga_
ragas65326063ra_gas
ragbag1045463ragbag
rage55742353ra__ge
ragee65432663ra_gee
raggee84217603raggee
raggle83712883raggle
raglan73711503raglan
ragman94013713ragman
ragtag836643ragtag
rah68052403ra_h__
raia46638383ra_ia_
raias54631123ra_ias
raise54828053ra_ise
raita54623073raita_
raitas64417673raitas
raja117918683ra_ja_
rajah155711423ra_jah
rajahs16497663rajahs
rajas127317723ra_jas
rake84841573ra__ke
rakee96031173ra_kee
rale45050563ra__le
rallye95110163rallye
ralph1078743ralph__
ralphed1334363ralphed
ralphs1135373ralph_s
ramal74622243ra_mal
ramate83921683ramate
ramble104519973ramble
ramee74633853ra_mee
ramie75027823ra_mie
ramose8314403ramose
rampage1237453rampage
rampike1536603rampike
rampole1139693rampole
rance75028513ra_nce
randan7315253randan
ranee55438103ra_nee
range64728413ra_nge
rankle103414883rankle
ranpike1335933ranpike
rap56261963rap___
raped85334623rap_ed
raper74932753rap_er
rapers84327183rapers
rapes75740723rap_es
raphides14188393raphides
rapid86422033rap_id
rapider1067903rapider
rapids94913893rapids
rapier84019993rapier
rapines95120863rapines
raping94829853raping
rapini84714683rapini
rapist82520673rapist
rapparee1245873rapparee
rapped114122683rapped
rappees113611453rappees
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
raps66247733rap__s
rapt67245313rap__t
raptly11338913raptly
raptor83912823raptor
rapture937383rapture
rare45348433ra__re
rascal8511123rascal
rase46149983ra__se
rash76039933rash__
rasher95024123rasher
rashes95330153rashes
rashly123410213rashly
rassle63813203rassle
rasure6311423rasure
ratal55025113ra_tal
ratan53722663ra_tan
ratbag956563ratbag
rate45458763ra__te
rath76037663rath__
rather94319743rather
rathole10312053rathole
ratine65131823ratine
ratite65022423ratite
rattan63613603rattan
rattle64717613rattle
ravage1039303ravage
rave75542093ra__ve
ravine95522223ravine
rawhide14134973rawhide
raya75224823ra_ya_
rayah116013503ra_yah
rayahs12579193rayahs
rayas85922053ra_yas
raze135235433ra__ze
razee145827803ra_zee
rediae74221993rediae
reggae858953reggae
rehab10312443r_ehab
repave114813873repave
repay104818453rep_ay
repeal84718283repeal
repeat85127213repeat
rephrase1346733rephrase
repine85627813repine
replace113214283replace
replan83215823replan
replate93420053replate
replay113412923replay
repose84121413repose
repute84716093repute
reshape1249043reshape
reshave1338603reshave
reshoe92816483reshoe
rhaphes1534703rhaphes
rhea75017433r__hea
ripe66038923rip__e
ripple103413913ripple
riprap1055513riprap
ripsaw1134283ripsaw
rope65542913rop__e
ruche104216763ruch_e
rugae65114763r_ugae
rupee7321283rup_ee
rupiah1146213rupiah
rushee93818773rushee
sadhe94815133sadh_e
salpae84614273salpae
saphead1357773saphead
saphenae1344853saphenae
sapote8314363sapote
sashay1238363sashay
spae65034323_sp_ae
spahee11313443spahee
sradha1085333sradha_
sradhas1176153sradhas
tache106222373tach_e
takahe1335793takahe
tapa65129143tap_a_
tapas74627713tap_as
tape64538143tap__e
taphole1239773taphole
thae76825563__thae
tophe106718973toph_e
trachea12311673trachea
tracheae1349113tracheae
trachle12311853trachle
trapan82412973trap_an
trapeze1836253trapeze
triphase1346193triphase

Search took 7 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.373479064.3
2DLD Change Limit1127163145.90619085.0
3Display Results3143140.1102854.5
 (SQL Overall)1786913146.38927968.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.