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

293 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
afraid104972(None) 
acarid95017072acarid
acrid86920102acr_id
afeard1058262afeard
affair1234352affair
afrit8323172afr_it
aramid93315612a_ramid
arid57642712a_r_id
aroid65428342a_roid
braid85822262_braid
farad95720672fara_d
frail85220212_frail
fraud939862_fraud
raid55243072__raid
unafraid1242662unafraid
abfarad1344223abfarad
aboard9312613aboard
abrade9313053abrade
abraded1138643abraded
abri65522213abr_i_
abris75722603abr_is
abroad9310943abroad
acari75020283acari_
acarids105312243acarids
acaroid103512313acaroid
acid77533393a__cid
acrasia9310033acrasia
acrasin9311223acrasin
acred87126353acr_ed
adroit7518793adroit
aerate64830553aerate
aerated85322373aerated
aerial64625713aerial
aerie54634603aer_ie
aeried74221863aeried
afar76720783af_a_r
afars85716513af_ars
afeared1176833afeared
affaire1344463affaire
affairs1334163affairs
affix1836003af_fix
afford1346493afford
affray1534973affra_y
affrayed1842843affrayed
affrays1644063affrays
afield1035953afield
aflame1138723aflame
aforesaid1343263aforesaid
afreet9315153afreet
afresh1255503afresh
afrits9311903afrits
again65218123a_gain
agamid103710693agamid
agaric93513633agaric
agnail739533agnail
agrafe1038093agrafe
agravic1345893agravic
agreed84712503agreed
agria65517143agr_ia
agrias74315393agrias
ahead96817053ahea_d
aid49269073___aid
aired66032923air_ed
airmail946213airmail
airted74214503airted
airward1148133airward
aland65526413a_land
alcaic1039983alcaic
alcaide1088453alcaide
alcid85817973a_lcid
algid75415583a_lgid
algoid83011473algoid
amain74922913a_main
ambroid1238883ambroid
amid77036353a__mid
android9311513android
aneroid8313993aneroid
antacid10311223antacid
aortic8316613aortic
aphid115515393a_phid
apraxia1646893apraxia
apraxic1846293apraxic
arabic10312733a_rabic
arak86929573a_ra_k
araks94820883a_raks
arame75026623a_rame
aramids102810513a_ramids
araneid8310803a_raneid
arced88224163a_rced
areic73219393a_reic
argil65116883a_rgil
aria46245423a_r_ia
arias55438023a_rias
aril45843023a_r_il
armed86324433a_rmed
aroids75118223a_roids
arrack121110253arrack
arraign845063arraign
arrant6623253arrant
arras55626133arra_s
arrased8149863arrased
array86317143arra_y
arrayed11117153arrayed
arrays95311683arrays
arris56824683a_rris
arsis55722423a_rsis
ascarid103910723ascarid
asrama839193asrama
assai5711543assai_
assail6610153assail
assais6711963assais
atria56022343atr_ia
atrial65418943atrial
atrip75315753atr_ip
attain6311753attain
atwain937813atwain
audad71511393auda_d
aura45836253aura__
aurae54128113aura_e
aural54428963aura_l
aurar54420253aura_r
auras55932553aura_s
aurate64426473aurate
aurated83817793aurated
aurei54821863aurei_
auric74521733aur_ic
auris55331533aur_is
avail8313883a_vail
avid88325963a__vid
avoid95516683a_void
await85524493a_wait
award97118043a_ward
bandaid11310483bandaid
barmaid1238203barmaid
brad75234343_bra_d
braids95015693_braids
brail75525553_brail
brain76229383_brain
brand85124493_brand
caid77837533__caid
carabid12311333carabid
cervid1239323cervid
corvid12310473corvid
defraud1243913defraud
derail74218813derail
drail65020973_drail
drain65222893_drain
droid74218543_droid
druid74111323_druid
errand758793errand
fad77452413_f_a_d
fail74840243_f_ail
fain75840563_f_ain
fair76332523_f_air
faradic1337693faradic
farads104713273farads
farced125216533farced
farci105919313farci_
farcie114816473farcie
fard85639063_f_ard
farded114518953farded
fared95842343far_ed
farmed125117653farmed
farside1138603farside
farted105121783farted
felid94717173_felid
fervid1337513fervid
fetid93715983_fetid
fid76847683_f__id
flail85316183_flail
flair86114123_flair
fluid94013963_fluid
forbid123312433forbid
fordid113512053fordid
frae75330473_fra_e
frag85126273_fra_g
frags96322163_frags
frails93716473_frails
fraise94214913_fraise
frame105821803_frame
framed125116523_framed
franc104615413_franc
frank124417513_frank
frap95925813_fra_p
fraps105620553_fraps
frass85321123_frass
frat75648543_fra_t
frats86829673_frats
frauds1036753_frauds
fray105428903_fra_y
frayed135012163_frayed
frays116920103_frays
frazil1847223_frazil
freed95223543_freed
fremd115010323_fremd
friar85414273_friar
fried95322913_fried
frig85424503_fr_ig
frigid1136923_frigid
frit77044473_fr_it
friz166324343_fr_iz
frond95316343_frond
fruit85122223_fruit
grad66829863_gra_d
grail64622873_grail
grain65126253_grain
grand75122693_grand
gravid113710983_gravid
grid65829613_gr_id
herald10311343herald
horrid10311553horrid
inlaid7310143inlaid
irid55927173_ir_id
jerid132316423jer_id
jerrid14259143jerrid
korai97018513korai_
krait94726773_krait
labroid1038823labroid
laid56439143__laid
lurid64618973lur_id
maid75537653__maid
maraud938943maraud
mermaid1297853mermaid
morbid112511463morbid
murid84520583mur_id
myriad1235913myriad
navaid1037653navaid
naysaid1145313naysaid
nereid7312923nereid
orad56031693_ora_d
paid75737483__paid
parfait12312053parfait
peracid12312993peracid
plaid85118303_plaid
pyralid1347983pyralid
pyramid1547513pyramid
qaid146023843__qaid
rabid84520783__rabid
rad47662003__ra_d
rai37658223__rai_
raia46638383__raia
raids65827513__raids
rail46147763__rail
rain46251733__rain
rais45252623__rais
rand55839563__rand
ranid66429333__ranid
rapid86422033__rapid
refrain10310043refrain
relaid75518443relaid
repaid94716323repaid
resaid74517083resaid
rid46754623__r_id
safari91110223safari_
safaried1236253safaried
safaris101110663safaris
safranin1145213safranin
said55742113__said
serai56830163serai_
serail64222673serail
serais64326133serais
sordid83411153sordid
sparid94016933sparid
sprain83614863sprain
staid66722073_staid
strain64919573strain
strait64025893strait
strand74514823strand
taffrail1442353taffrail
taxpaid1743093taxpaid
terai53525483terai_
terais64023503terais
toroid7416013toroid
torpid9310913torpid
torrid7311853torrid
trad55630913_tra_d
traik95418203_traik
trail55126773_trail
train56529113_train
trait56940843_trait
triad65217723_triad
turbid979713turbid
turgid868013turgid
unbraid1037183unbraid
unlaid7311753unlaid
unpaid939473unpaid
unsaid7411833unsaid
upbraid1244973upbraid
ursid6311483_ursid
verbid122311313verbid
virid94116043vir_id
viroid10411523viroid
waylaid1445093waylaid

Search took 6 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.1431249587.4
2DLD Change Limit1127162935.60620106.3
3Display Results2932930.0933150.5
 (SQL Overall)1786912935.84230587.3
 
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.