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

214 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
radical10331279(None) 
radial74020391radi_al
radicals112610151radicals
radicel10278871radicel
apical10913902_apical
biradical14105322biradical
laical8312322la_ical
magical1239782magical
medical12312512medical
nadiral836342nadiral
nodical1049862nodical
racial83419242raci_al
radiale83813522radi_ale
radials83614632radi_als
radian74117272radi_an
radically15310422radically
radicand12115282radicand
radicate11412872radicate
radicels11297182radicels
radices102314262radices
radicle103510712radicle
rascal8511122ra_scal
redial74923112redi_al
tragical1148212tragical
vatical1239982vatical
abapical1444943abapical
admiral1046363_admiral
aecial84817313_aecial
animal85016253_animal
apicals1159923_apicals
arabica1147283arabica_
arabicas1247193arabicas
arnica8310443arnica_
arnicas939543arnicas
arrival1037563arrival
audial7312993audi_al
axial124515193_axi_al
basinal9310033basinal
biradial1167713biradi_al
biradicals15103643biradicals
caecal103713733ca_ecal
candidal12367733candidal
capital112311523capital
caracal11312513caracal
cardinal1139553cardinal
carinal94318223carinal
codicil1246803codicil
comical13312223comical
conical11316203conical
cranial92114683crani_al
critical12310263critical
cubical1338463cubical
cynical1437873cynical
dandiacal1352193dandiacal
datival1135583datival
decal85523233__decal
dial55935063__di_al
domical1239373domical
druidical1343013druidical
ducal84816423__ducal
edictal1046993_edictal
epical10413393_epical
eradicable1545633eradicable
eradicant1246933eradicant
eradicate1259183eradicate
erotical101911983erotical
erratical1146903erratical
ethical1238443ethical
facial113615633faci_al
faecal11359813fa_ecal
farcical1546953farcical
fascial1258303fascial
fatidical1544243fatidical
faucal11339963fa_ucal
faucial1257323faucial
finical1239693finical
gavial10310083gavi_al
gradual936943grad_ual
graphical1745883graphical
hadal95518123had__al
handicap1644933handicap
haptical1547343haptical
helical12311153helical
iatrical1049273iatrical
indican1048243indican
irenical1048553irenical
ironical1049963ironical
jacal14313703ja__cal
judicial1844643judicial
juridical1943703juridical
labial84714343labi_al
laminal94113633laminal
lanital7310913lanital
lexical1637363lexical
logical1038513logical
lyrical1236493lyrical
madcap1336333mad_cap
madrigal121627253madrigal
maniacal1246723maniacal
marital92314183marital
matinal9312603matinal
maximal18347093maximal
medial93819863medi_al
medicals1349363medicals
metical11315363metical
mimical1339233mimical
modica11310063modica_
monadical1446133monadical
musical1139553musical
narial6317953nari_al
nasial6413283nasi_al
nautical1057703nautical
nudicaul1142253nudicaul
oedipal1045173oedipal
optical1149863optical
ordinal838633ordinal
orphical1546723orphical
paginal10269493paginal
paradisal1246883paradisal
parodical1447563parodical
pascal10812373pa_scal
pedicab1446693pedicab
pedicel1237813pedicel
pedocal1237893pedocal
pical95524373__pical
piratical1348653piratical
plical10411683_plical
practical1548843practical
praedial1178763praedi_al
prandial1149643prandi_al
predial103815413predi_al
prodigal1246003prodigal
rabic93817403rabic__
rachial122012173rachial
radar61316723rad__ar
radiable11611303radiable
radialia946313radi_alia
radially1239783radially
radians83013823radians
radiant82817133radiant
radiate83416313radiate
radicalise1346133radicalise
radicalism1545873radicalism
radicalize2246303radicalize
radicands13154673radicands
radicated13410123radicated
radicates12412073radicates
radicles11249703radicles
radicular1245883radicular
radii64016413radi__i
radio64922493radi__o
radioed939673radioed
radioman1145773radioman
radios74018673radi_os
radish103516913radi_sh
radium93513293radi_um
radiums10299303radiums
radius73914863radi_us
radix134414593radi__x
radixes15259343radixes
radula749313radula_
radulae837963radulae
radular837833radular
radulas839583radulas
raia46638383ra_i_a_
raias54631123ra_i_as
rail46147763ra_i__l
railcar945483railcar
raita54623073ra_ita_
raitas64417673ra_itas
ramal74622243ra__mal
rascals959663ra_scals
ratal55025113ra__tal
rational8412543rational
recital9412163recital
redcap1158493red_cap
redia65524483redi_a_
rediae74221993redi_ae
redials84416883redi_als
redias74523603redi_as
reginal84814293reginal
retial64724993reti_al
retinal75318353retinal
revisal1038263revisal
revival1337033revival
rhinal9510183r_hinal
rial45938093r__i_al
rictal83113173r__ictal
ridicule1144393ridicule
rival85216503r__ival
riyal84413433r__iyal
rubrical1296093rubrical
ruderal837373ruderal
ruminal9289993ruminal
rustical1048393rustical
sahiwal1344443sahiwal
statical1039423statical
stoical9310273stoical
syndical1445373syndical
tactical1248843tactical
taxicab1843413taxicab
tical76021493__tical
topical1139953topical
toxical1637643toxical
tropical1248733tropical
typical1436343typical
uredial82910483uredi_al
vaginal11288403vaginal
veridical1545983veridical
vesical12159813vesical
viatical1347063viatical
wadmaal1343203wadmaal
wadmal1237283wad_mal
zodiacal2042243zodiacal

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.1531167915.0
2DLD Change Limit1340272147.52017822.7
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.74923059.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.