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

279 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
raphia11351126(None) 
raphias123511081raphias
raphis114014321raphis
agraphia1445242agraphia
aphid115515392_aphid
aphis105917132_aphis
brachia141910422brachia
daphnia1345052daphnia
graphic1537352graphic
paphian1437452paphian
rachial122012172rachial
rachis114017652rachis
raffia12287702raffia
raia46638382ra__ia
raphae114311732raphae
raphe104916422raph_e
raphes115117452raphes
raphide13138072raphide
rapid86422032rap_id
abrachia1545843abrachia
acapnia1145913acapnia
aecia73819283_aecia
agha87417303_agh_a
agrapha1345133agraph_a
agraphias1545073agraphias
agraphic1646183agraphic
agria65517143_agria
aha611246643_a_h_a
ahi68040233_a_hi_
ahis76135383_a_his
alpha1049653alph_a
amia66836903_a_mia
amnia75918643_amnia
aphagia13247663_aphagia
aphasia122510873_aphasia
aphelia1249423_aphelia
aphids125110843_aphids
aphonia122711883_aphonia
aphtha1444483_aphtha
apian75018333_ap_ian
apnea73413413_apnea
aporia8315863_aporia
apsis75718293_apsis
arapaima1243483arapaima
archil11611573archil
aria46245423_a_ria
arshin9312173arshin
atria56022343_atria
atrophia1348113atrophia
brachial15219303brachial
brahma1336193bra_hma
branchia15217713branchia
cambia124913153cambia
caph116623293caph__
caphs124515373caph_s
capias10318353cap_ias
capita102913773capita
capiz18514563cap_iz
caplin103216303caplin
capric12411803capric
capris10415083capris
capsid11312413capsid
cardia9916383cardia
cassia83714763cassia
chia96026623__chia
crania82418433cra_nia
crapola1136913crapola
crappie13298983crappie
dacha114812573dach_a
dahlia1035773dahlia
daphne12237013daphne
daphnias1444683daphnias
dashi95013113dashi_
dashis104414393dashis
dauphin1344383dauphin
drachma1544303drachma
edaphic1544243edaphic
epha9310053_eph_a
facia103218463fa_cia
fascia1148703fascia
gambia115912253gambia
graph115315613graph__
graphed1498473graphed
graphical1745883graphical
graphics1645653graphics
graphing1538533graphing
graphite1447153graphite
graphs124510153graph_s
graplin1058443graplin
grappa11396443grap_pa
haha107821063ha_h_a
haptic13511893haptic
hypha1637383hyph_a
ischia1136393ischia
kachina1637663kachina
kalmia1238893kalmia
kapa106021293kap__a
kaph135815753kaph__
kaphs144911503kaph_s
kappa13469743kap_pa
kasha124710723kash_a
labia75219013la_bia
lamia75324323la_mia
lapin75222923lap_in
lapis76223153lap_is
lathi85417203lathi_
lathis95516173lathis
latria62313603latria
lithia939333lithia
lochia1158313lochia
macchia1645893macchia
maffia14327203maffia
mafia104418033ma_fia
mania75634153ma_nia
maria75032883ma_ria
mashie11315933mashie
morphia1447483morphia
napa66927263nap__a
naphtha1542923naphtha
napkin1236903napkin
nappa98511863nap_pa
nappie104112263nappie
ohia75719363__ohia
orphic1368323orphic
pacha126518063pach_a
pallia83015593pallia
papa85827143pap__a
papain10313793papain
papaya1337503papaya
paphians1545593paphians
pappi84810893pappi_
paprica1337003paprica
paprika1544003paprika
papula103011113papula
pasha105417183pash_a
phi86524203__phi_
phial10313203__phial
phis95724903__phis
phiz186718843__phiz
pia56848033__p_ia
propria1149933propria
rabbi93113183rabbi_
rabbin103112303rabbin
rabbis102613163rabbis
rabbit102914563rabbit
rabic93817403ra_bic
rabid84520783ra_bid
rachet115028973rachet
rachilla1345713rachilla
racial83419243ra_cial
radial74020393ra_dial
radian74117273ra_dian
radii64016413ra_dii
radio64922493ra_dio
radix134414603ra_dix
radula749313radula
raffias13237713raffias
raga55930813ra__ga
ragi56032283ra_gi_
ragis66325603ra_gis
rah68052403ra_h__
rai37658223ra__i_
raias54631123ra__ias
raid55243073ra__id
rail46147763ra__il
rain46251733ra__in
rais45252623ra__is
raisin62716923raisin
raita54623073ra_ita
raja117918683ra__ja
raki87127833ra_ki_
rakis95323443ra_kis
ralph1078743ralph__
ralphed1334363ralphed
ralphing1435413ralphing
ralphs1135373ralph_s
ramada9310183ramada
rambla103510933rambla
rami66034093ra_mi_
ramie75027823ra_mie
ramona8412413ramona
ramtil8311033ramtil
rancid9513863rancid
rani46640113ra_ni_
ranid66429333ra_nid
ranis55235833ra_nis
ranula6311813ranula
rap56261963rap___
rape65041633rap__e
raped85334623rap_ed
raper74932753rap_er
rapers84327183rapers
rapes75740723rap_es
raphides14188393raphides
rapids94913893rapids
rapier84019993rapier
rapine85023083rapine
raping94829853raping
rapini84714683rapini
rapist82520673rapist
rapped114122683rapped
rappee103618673rappee
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
rapping123619103rapping
rappini11347573rappini
raps66247733rap__s
rapt67245313rap__t
raptly11338913raptly
raptor83912823raptor
rash76039933rash__
rasher95024123rasher
rashes95330153rashes
rashly123410213rashly
ratafia1045773ratafia
rath76037663rath__
rathe85821923rath_e
rather94319743rather
ratio55227583ra_tio
ratlin64116523ratlin
ravin85624653ra_vin
rawhide14134973rawhide
rawin85521473ra_win
raya75224823ra__ya
realia6314593realia
redia65524483r_edia
repaid94716323repaid
repair84011463repair
repin75324703rep_in
replica1137943replica
reship11310673reship
retia55326113r_etia
rhachis1555693rhachis
rhaphae1543193rhaphae
rhaphe1433423rhaph_e
rhaphes1534703rhaphes
rhea75017433r__hea
ria36745503r___ia
rishi8311253rishi_
rishis9312453rishis
roshi8310753roshi_
roshis9311793roshis
rupiah1146213rup_iah
sahib10314763sa_hib
salvia93310753salvia
saphead1357773saphead
saphena1235863saphena
sapid84720933sap_id
sapota8310213sapota
sapphic1644553sapphic
sepia75318673sep_ia
seraphic1546633seraphic
seraphim1544803seraphim
seraphin1345953seraphin
spahi10311143spahi_
spahis11310383spahis
sradha1085333sradh_a
taenia6313193taenia
taffia12286903taffia
tafia84215493ta_fia
tapa65129143tap__a
tapeta8310693tapeta
tapir75917063tap_ir
tapis75028863tap_is
tarsia65514273tarsia
tephra1136483tephra
teraphim1545003teraphim
tophi105215303tophi_
trachea12311683trachea
trapezia1944333trapezia
trophic14311033trophic
uraemia946503uraemia
urania62516123ura_nia
vapid115614283vap_id
varia85824203va_ria
yautia937253yautia
zamia165115213za_mia
zaptiah2144293zaptiah

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.500357382.0
2DLD Change Limit1127162795.53320371.6
3Display Results2792790.0933000.0
 (SQL Overall)1786912796.12629169.3
 
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.