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

188 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
rachial12201217(None) 
brachial15219301brachial
racial83419241rac_ial
achiral12109182_achiral
archil11611572archi_l
archival1645782archival
brachia141910422brachia_
brachials16206942brachials
branchial16215962branchial
facial113615632fac_ial
ischial1246422ischial
lochial1257082lochial
rachilla1345712rachilla
rachis114017652rachi_s
radial74020392ra_dial
raphia113511262raphia_
raphias123511082raphias
tracheal1348252tracheal
abrachia1545843abrachia_
abrachias1645633abrachias
acetal84314903_acetal
achenial1348283_achenial
achier113914263_achier
aching126521973_aching
actinal9312293_actinal
actual8311023_actual
aecial84817313_aecial
aerial64625713_aerial
archaeal13115463archaeal
archaic1438823archaic
archaical1645903archaical
archean1269123archean
archils12510533archils
archine125817053archine
arching136216693arching
archive154610483archive
archrival1743383archrival
archway1844893archway
arrhizal2042953arrhizal
atrial65418943_atrial
audial7312993_audial
awhirl1264673_awhirl
axial124515193_a_xial
baching156017753baching
bathyal1544823bathyal
biracial12107973birac_ial
brachiate1646873brachiate
brachium1766113brachium
bracteal1245563bracteal
branchia15217713branchia_
branchiae16186313branchiae
breccial1444693breccial
bronchial16175333bronchial
caching156317503caching
cambial134010763cambial
chia96026623__chia_
chiao105618363__chiao
chias104625523__chias
chiel104918973__chiel
chill105619873__chill
chiral114614413__chiral
chital114313883__chital
cranial92114683cra_nial
crucial1157893cruc_ial
dacha114812573dach_a_
dachas124113253dach_as
decrial10310323decrial
drachma1544303drachma_
drachmae1643933drachmae
drachmai1653243drachmai
drachmas1644863drachmas
eparchial1644403eparchial
facia103218463fac_ia_
faciae112913413fac_iae
facials123310743fac_ials
facias113415803fac_ias
factual1246723factual
fascial1258303fascial
faucial1257323faucial
fecial114714623fec_ial
fractal1237623frac_tal
gavial10310083ga_vial
glacial1038143glac_ial
graphical1745883graphical
ischia1136393ischia_
jacal14313703jac__al
jackal1937613jac_kal
kachina1637663kachina
kachinas1736343kachinas
labial84714343la_bial
lacrimal1244443lacrimal
lacteal966823lacteal
lacunal9136553lacunal
lochia1158313lochia_
macchia1645893macchia_
machine14313493machine
martial92415413martial
mochila1446523mochila
nachas114914193nach_as
narial6317953na_rial
nasial6413283na_sial
nuchal11218873nuch_al
orchil1158653orchi_l
pacha126518063pach_a_
pachas135017143pach_as
pachisi14329523pachisi
pallial92911253pallial
paphian1437453paphian
parochial1646183parochial
partial92616263partial
paschal14157243pasch_al
phial10313203__phial
practical1548843practical
praedial1178763praedial
prandial1149643prandial
prechill1546193prechill
racewalk1744063racewalk
raceway1546133raceway
rachet115028973rach_et
rachets124516833rachets
rachides141511223rachides
rachillae1443663rachillae
rachises131412413rachises
rachitic1547593rachitic
rachitis1348353rachitis
racially1339623rac_ially
racier85120973rac_ier
racily11715173rac_ily
racing95030533rac_ing
racism103214193rac_ism
racist82822793rac_ist
rackful1645873rackful
racking144323663racking
radiale83813523ra_diale
radials83614643ra_dials
radian74117273ra_dian
radical103312793radical
raffia12287703raffia_
raffias13237713raffias
raia46638383ra__ia_
raias54631123ra__ias
rail46147763ra__i_l
ramal74622243ra__mal
ramtil8311033ramti_l
ranching141712043ranching
ranchman1546043ranchman
raphae114311733raph_ae
raphide13138073raphide
raphis114014323raphi_s
rascal8511123ra_scal
rasorial848223rasorial
ratal55025113ra__tal
rattail737803rattail
rawhide14134973rawhide
reaching143317203reaching
recheat12415933recheat
recital9412163recital
recoal84117973rec_oal
recoil84016723recoi_l
rectal84418133rec_tal
recusal968673recusal
redial74923113r_edial
retial64724993r_etial
retrial7615553retrial
rhachis1555693rhachi_s
rhinal9510193r__hinal
rhonchial1752263rhonchial
rial45938093r___ial
rictal83113183ric_tal
roaching143210433roaching
ruching133612933ruching
sacral83414413sac_ral
sahiwal1344443sa_hiwal
social8813333soc_ial
spacial1138763spac_ial
tachism1478873tachism
tachist12613293tachist
tactical1248843tactical
tactual936203tactual
trachea12311683trachea_
tracheae1349113tracheae
tracheas13410273tracheas
trichinal1445663trichinal
trochal1288243troch_al
trochil1258713trochi_l
uncial83715223unc_ial
uracil8311543urac_i_l
vaccinal1544903vaccinal

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.406440125.6
2DLD Change Limit1340271886.65620136.3
3Display Results1881880.0802350.0
 (SQL Overall)1786911887.14225019.7
 
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.