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

108 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
journal148496(None) 
journals1574351journals
diurnal844882diurnal
joual12311652jou__al
journaled1742672journaled
journey1734872journey
journo13135292journ_o
journos14134942journos
jural125120482j_ur_al
nounal639812nou_nal
anural65714743anur_al
aortal65217513ao_rtal
aural54428963_aur_al
boral75831703bo_r_al
boreal84817213bo_real
bourn75518483bourn__
bourne83714093bourn_e
bournes93615023bournes
bourns84114063bourn_s
burial84117623_burial
bursal84414823_bursal
carnal83919203_carnal
columnal1244413columnal
coral76033453co_r_al
corneal94414503co_rneal
cornel84020053co_rnel
cornual94210173co_rnual
coronal94115763coronal
corral83616253co_rral
cothurnal1442523cothurnal
courant9317973courant
courlan9117763courlan
crural8610633crur_al
curial84019153_curial
curtal83914543_curtal
dhurna1043563dhurna_
dhurnas1153443dhurnas
diurnals943803diurnals
doornail943573doornail
dorsal74613943do_rsal
doura66518663dour_a_
dourah10479813dour_ah
douras75016723dour_as
dural64923893_dur_al
eternal72910893eternal
faunal94711593fau_nal
formal113215203fo_rmal
gooral7310463goor_al
goral65125753go_r_al
horal86328683ho_r_al
jejunal1342833jejunal
joram145816983jo_r_am
jordan1468063jo_rdan
jouals1338923jou__als
jounce153310733jou_nce
jouncy18336203jou_ncy
journalese1752123journalese
journaling1843173journaling
journalism1953873journalism
journalist1755003journalist
journalize26113943journalize
journeys1843203journeys
jovial1636543jo_vial
jugal135612403j_u_gal
jumbal1758463j_umbal
jura116024893j_ur_a_
jurant134216553j_urant
jurat124829323j_ur_at
jurel124516333j_ur_el
juvenal1743393juvenal
koruna1035483koruna_
korunas1135443korunas
loral55927823lo_r_al
loreal63814313lo_real
moral75533433mo_r_al
mortal84616853mo_rtal
mourn77215013mourn__
mourned1037763mourned
mourner938093mourner
mournful1342503mournful
mourns84111013mourn_s
mural75225113_mur_al
neural6311993neur_al
neuronal846893neuronal
nocturnal1143233nocturnal
nominal92712373nominal
normal83213533no_rmal
noumenal1046173noumenal
oral47638123_o_r_al
ourang73311063_ourang
plural839823plur_al
portal84218463po_rtal
poundal1036403poundal
rural55821173_rur_al
sourball1045363sourball
sternal73411913sternal
sural55931263_sur_al
tarnal63716503_tarnal
tonal53724303to__nal
tourney1036273tourney
ureal56722683__ureal
urial54823023__urial
urinal6614123__urinal
vernal93514213_vernal
yourn87512773yourn__
zoarial1646923zoarial
zonal145116853zo__nal
zoonal1558083zo_onal

Search took 9 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.390458182.1
2DLD Change Limit1340271088.37616001.3
3Display Results1081080.0303600.0
 (SQL Overall)1786911088.79620315.0
 
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.