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

165 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
natural73951(None) 
naturals847901naturals
antral65719412ant_ral
anural65714742_anural
aural54428962_a_ural
datura738022datura_
daturas838762daturas
futural1037282futural
lateral7313562lateral
nadiral836342nadiral
natal53921492nat__al
naturally1246522naturally
nature6311262natur_e
natured838962natured
natures7311962natures
neural6311992n_eural
neutral737922neutral
nurtural845492nurtural
pastural1038412pastural
sutural7310222sutural
unnatural943612unnatural
aboral8314373_aboral
actual8311023actu_al
amoral8314623_amoral
annual64710703annu_al
antheral1149393antheral
anthrax1757153anthrax
antra56521923ant_ra_
anuran64313243_anuran
apteral9311523apteral
astral66919283_astral
atabal839743_atabal
atonal6514023_atonal
atrial65418943_atrial
augural856403augural
aura45836253_a_ura_
aurae54128113_a_urae
aurar54420253_a_urar
auras55932553_a_uras
bathyal1544823bathyal
binaural1045403bina_ural
butyral1245713butyral
caesural1055383caesural
cameral11311263cameral
caporal11410943caporal
casual81112863casu_al
cateran9313763cateran
caudal91611483ca_udal
causal81413203ca_usal
citral81113883cit_ral
connatural1254343connatural
creatural1144893creatural
crural8610633_crural
cultural1047253cultural
datival1135583datival
daturic1047003daturic
dentural948083dentural
dural64923893__dural
enteral73516433enteral
enthral103410933enthral
estral64716513est_ral
estrual7367933estrual
factual1246723factu_al
fatal84819373fat__al
faucal11339963fa_ucal
faunal94711593fa_unal
figural1145233figural
fractural1444553fractural
gastral8329553gastral
gestural946033gestural
gnathal1144353gnat_hal
guttural943803guttural
inaugural1052343inaugural
inthral10249463inthral
junctural1842903junctural
jural125120483__jural
katsura1143753katsura_
katsuras1243653katsuras
lacunal9136553lacunal
laterad8310833laterad
laterals8312743laterals
laura54116203la_ura_
laurae64011663la_urae
lauras63414333la_uras
laurel649033la_urel
literal7613263literal
litoral7610763litoral
macrural1244953macrural
manual8313463manu_al
manurial1047783manurial
material10314093material
maternal1047803maternal
matinal9312603matinal
maturate10312613maturate
mature8313463matur_e
matured10310033matured
maturely1344893maturely
maturer938973maturer
matures9314303matures
mayoral1237683mayoral
mitral81314323mit_ral
monaural1046203mona_ural
mural75225103__mural
mutual838503mutu_al
naira5314743na_ira_
nairas6312773na_iras
narial6317953na_rial
narwal938943na_rwal
narwhal1344333narwhal
nasal56217593na__sal
nasial6413283na_sial
national8311533national
natron64116023nat_ron
naturalise1047113naturalise
naturalism1247333naturalism
naturalist1048863naturalist
naturalize1956893naturalize
naturism1047893naturism
naturist8410813naturist
nautical1057703nautical
naval85315833na__val
neutrals846283neutrals
nitril62511533nit_ril
nocturnal1143213nocturnal
nonnatural1054493nonnatural
nonoral7313593nonoral
nonrural847353nonrural
notal55221353not__al
notarial8410743notarial
nounal639813n_ounal
numeral939083numeral
nurl45327243n__ur_l
oatmeal944973oatmeal
paludal1035683paludal
papyral1445773papyral
parral85517533pa_rral
parura8310583parura_
paruras9310533paruras
pastoral10310483pastoral
paternal1038333paternal
patrol83213023pat_rol
pausal81511963pa_usal
pleural956673pleural
plural839823_plural
postural1049193postural
ratal55025113rat__al
rattrap945263rattrap
retral64419743ret_ral
ritual6310613ritu_al
rural55821173__rural
sacral83414413sa_cral
samurai945923samurai
satara6315533satara_
sataras7315053sataras
satrap86212553sat_rap
saturable1146633saturable
saturant8410643saturant
saturate8312813saturate
saurel6511983sa_urel
sural55931263__sural
tactual936203tactu_al
textural1544943textural
tubal75517203__tubal
vatical1239983vatical
vestural1156473vestural

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271656.43620824.6
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.65526850.6
 
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.