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

145 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
numeral93908(None) 
humeral1238561humeral
numerals1047331numerals
cameral11311282cameral
funeral1037622funeral
gomeral1038832gomeral
humerals1347172humerals
humoral1237972humoral
lumenal9307272lumenal
noumenal1046172noumenal
numerable1347622numerable
numerably1645972numerably
numeracy1544082numeracy
numerally1446132numerally
numerary1344282numerary
numerate101610392numerate
numeric1158192numeric
numerical1345972numerical
puberal1147772puberal
ruderal837372ruderal
tumoral938132tumoral
umbral1038632_umbral
unmoral948692unmoral
admiral1046363admiral
adumbral1342343adumbral
amoral8314633_amoral
antheral1149393antheral
anural65714743anu__ral
apteral9311523apteral
augural856403augural
aural54428963au__ral
auroral7310473auroral
austral73411513austral
bimetal1138433bimetal
butyral1245713butyral
camera10313693camera_
camerae11312063camerae
cameras11313363cameras
cuneal8611513cune_al
demersal1145273demersal
dural64923893du__ral
emerald1046923_emerald
enteral73516443enteral
enumerable1444973enumerable
enumerate11127353enumerate
federal1148533federal
femoral1238723femoral
feral85424653__feral
fumer105918233fumer__
fumers113613383fumer_s
funerals1146453funerals
funereal1143943funereal
futural1037283futural
gametal1037603gametal
general81010933general
gomerals1147443gomerals
gomerel1036393gomerel
gomeril1047383gomeril
gunmetal1143213gunmetal
humeri1138523humer_i
humerus1236913humerus
hymenal1545183hymenal
immoral1146783immoral
jumbal1758463jum_bal
jural125120483ju__ral
juvenal1743393juvenal
lateral7313573lateral
liberal9310193liberal
literal7613273literal
luminal93711003luminal
lustral7339653lustral
luteal64411483lute_al
meal65643173__me_al
medal86221333__medal
merl65830973__mer_l
metal75427383__metal
mineral9312733mineral
moral75533433__moral
mural75225113__mural
nadiral836343nadiral
namer75622103namer__
namers84517333namer_s
nametag1044443nametag
natural739513natural
nerol51017813n__erol
neural6311993n_eural
neutral737923neutral
nombril1145103nombril
nominal92712373nominal
nonmetal1049643nonmetal
nonmoral1049233nonmoral
nonoral7313603nonoral
noumena945633noumena_
novercal1345683novercal
nuchal11218873nu_chal
nucleal946693nucleal
nuder66416833nuder__
numbat10312083num_bat
number103913223number__
numberable1643993numberable
numbered13147143numbered
numberer12186313numberer
numbers113711243number_s
numen74216793nume__n
numerated12177873numerated
numerates11199573numerates
numerator1145583numerator
numerics1266283numerics
numerous1047843numerous
numina83510843numina_
nummary14314653nummary
nuptial946633nuptial
nurl45327243nu__r_l
nurtural845493nurtural
nutmeat947953nutme_at
nymphal1744033nymphal
penumbral1552653penumbral
pubertal1254323pubertal
quezal2435143qu_ezal
ruderals946073ruderals
ruminal9289993ruminal
rural55821173ru__ral
scleral937863scleral
seral56336383__seral
several1039533several
spheral1238423spheral
suboral92011993suboral
sudoral8148543sudoral
supernal1039873supernal
sural55931263su__ral
surreal739233surreal
sutural7310223sutural
timbral11237193timbral
tumbrel11406853tumbrel
tumbril11256403tumbril
umbra948513_umbra_
umbrae1038683_umbrae
umbras1038643_umbras
unmerry1245023unmerry
unreal64414453unre_al
unseal63315473unse_al
ureal56722683_ure_al
uveal84411073_uve_al
womera11137593womera_
womeras1287593womeras

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.406440125.6
2DLD Change Limit1340271456.51620568.9
3Display Results1451450.0463152.2
 (SQL Overall)1786911456.96825644.5
 
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.