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 “decimal” 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
decimal123808(None) 
decimals1345861decimals
aecial84817312aeci_al
decadal1137242decadal
decal85523232dec__al
decanal1038112decanal
decibel1235992decibel
decidual1244202decidual
decimally1745612decimally
decimate13411122decimate
decrial10310322decrial
decuman1236572decuman
deicidal1245712deicidal
denial74720512deni_al
dermal93614342de_rmal
devisal1136912devisal
fecial114714622feci_al
recital9412162recital
aecia73819283aeci_a_
aecidial1147253aecidial
aerial64625713aeri_al
animal85016253_animal
cecal94619113cec__al
ceramal1138843ceramal
comal95125133__comal
datival1135583datival
deadman11238423deadman
deal56347413de___al
decaf114919443dec__af
decals93717713dec__als
decamp1338453decam_p
decamps1435643decamps
decay114718483dec__ay
deciare10710663deciare
decibels1344523decibels
decidable1547223decidable
decide104116873deci_de
decided124312423decided
decider114213183decider
decides114217653decides
decidua1144493decidua
deciduae1243743deciduae
deciduas1243463deciduas
decigram1445353decigram
decile94619213deci_le
deciles104417723deciles
decimalize2446603decimalize
decimated1548953decimated
decimates14410693decimates
decimator1447733decimator
deckel134911043dec_kel
declaw1266703dec_law
decretal1146353decretal
decrials1137133decrials
dedal75719023de__dal
deifical1445543deifical
deil56231623de_i__l
delime9314043delim_e
delimed11310723delimed
delimes10314193delimes
delimit10311733delimit
denials84114133deni_als
denim85518843denim__
denimed1159233denimed
denims95214323denim_s
dental74319173de_ntal
dentinal939503dentinal
deposal1037153deposal
deprival1444603deprival
derma84918513de_rma_
dermas94116813de_rmas
deskman1444323deskman
desman9311693de_sman
despisal1144673despisal
detrital946573detrital
devil94714733devi__l
devisals1245613devisals
dextral1577003dextral
dial55935063d__i_al
digital937063digital
dismal92412243d_ismal
domal85619203d__omal
domical1239373domical
ducal84816423duc__al
ductal938993duc_tal
duncical1345213duncical
duodecimal1681093duodecimal
edictal1046993edictal
encinal949243encinal
epical10413393_epical
facial113615633faci_al
fecal105119213fec__al
fecials123510333feci_als
ferial94621253feri_al
fetial95716193feti_al
geminal10109903geminal
genial74917613geni_al
genital849793genital
geoidal936713geoidal
hectical1547933hectical
helical12311153helical
hemal104419803he__mal
incisal947373incisal
intimal9109943intimal
lacrimal1244443lacrimal
lexical1637363lexical
maximal18347093maximal
medial93819863medi_al
medical12312513medical
menial84223033meni_al
mesial84818083mesi_al
metical11315363metical
minimal114010603minimal
oedipal1045173oedipal
optimal1145783optimal
penial84120893peni_al
primal104014623_primal
racial83419243raci_al
recitals1039763recitals
recoal84117973rec_oal
rectal84418133rec_tal
recusal968673recusal
redial74923113redi_al
reginal84814293reginal
retial64724993reti_al
retinal75318353retinal
revisal1038263revisal
revival1337033revival
seconal9310073seconal
seismal937303seismal
semimat11412903semimat
seminal91213403seminal
serial64625863seri_al
serumal938783serumal
social8813333soci_al
special11310303speci_al
tectal83713253tec_tal
telial65815363teli_al
uncial83715223unci_al
uncinal959963uncinal
veinal93812963ve_inal
venial94218283veni_al
vesical12159813vesical
vicinal12268543vicinal
xenial133414903xeni_al

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.03322215.6
3Display Results1451450.0433372.1
 (SQL Overall)1786911456.48227567.3
 
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.