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 “uncinal” 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
uncinal95996(None) 
encinal949241encinal
uncial83715221unci_al
anconal939422anconal
anginal8310162anginal
duncical1345212duncical
encina8310442encina_
encinas938722encinas
incisal947372incisal
uncia75015162unci_a_
unciae83215312unci_ae
uncials92510522unci_als
uncinate10312392uncinate
uncini8310152uncin_i
uncinus937402uncinus
uncivil1244792uncivil
urinal6614122u_rinal
vicinal12268542vicinal
acinar8310483_acinar
actinal9312293actinal
aecial84817313aeci_al
affinal1336443affinal
albinal937813albinal
ancilla948603ancilla
anconeal1045593anconeal
angina7413133angina_
anginas8310953anginas
animal85016253an_imal
annal56520763an__nal
basinal9310033basinal
binal75323823__binal
canal75428043__canal
carinal94318233carinal
clinal8311553_clinal
decanal1038113decanal
decimal1238083decimal
dentinal939503dentinal
facial113615633faci_al
fecial114714623feci_al
final83922033__final
functional15116673functional
geminal10109903geminal
incivil1244933incivil
incudal1045863incudal
inguinal945603inguinal
intimal9109943intimal
invital1046953invital
junctional19105363junctional
lacunal9136553lacunal
laminal94113633laminal
liminal93810673liminal
luminal93711003luminal
matinal9312603matinal
municipal1543333municipal
nidal65217103_n_idal
nival84915773_n_ival
nominal92712373nominal
nonfinal1147703nonfinal
nounal639813_nounal
nuchal11218873nuc_hal
nucleal946693nucleal
numina83510843numina_
orcinol944703orcinol
ordinal838633ordinal
paginal10269493paginal
piscinal1285843piscinal
punctual1243903punctual
racial83419243raci_al
recital9412163recital
reginal84814293reginal
retinal75318353retinal
rhinal9510193_rhinal
ruminal9289993ruminal
runcinate1146473runcinate
seconal9310073seconal
seminal91213403seminal
social8813333soci_al
spinal84915313_spinal
succinyl1542573succinyl
suicidal1146073suicidal
sundial859863sundi_al
synclinal1443103synclinal
trinal6516963_trinal
turbinal1045623turbinal
umbonal1144383umbonal
unbind93011433unbin_d
unbinds10267353unbinds
uncanny1245113uncanny
uncap9312283unc__ap
unci65019463unci___
uncially1339073uncially
uncinaria11154423uncinaria
unclad938913unc_lad
unclean946973unclean
unclear936573unclear
unclinch1544873unclinch
uncloak1365473uncloak
uncoil8811853unc_oil
uncoined111813023uncoined
uncool8610113unc_ool
uncurl839413unc_url
uncynical1643893uncynical
undine7817263undin_e
undines8716083undines
unequal1644483unequal
unfilial1145343unfilial
ungenial946973ungenial
ungual738183un_gual
unhinge11237283unhinge
unideal837103unideal
unilineal943923unilineal
unisonal845373unisonal
unkind113310573unkin_d
unkindly1644883unkindly
unkingly1637253unkingly
unkink9308713unkin_k
unkinks10265413unkinks
unlined82515803unlined
unlink104011013unlin_k
unlinks11307403unlinks
unmined102612953unmined
unmingle1145913unmingle
unmoral948693unmoral
unnail6410583un__nail
unpin72613243unpin__
unpins82312383unpin_s
unreal64414453un_real
unseal63315473un_seal
unsinful1143823unsinful
unsnag736393un_snag
unsnap836203un_snap
unsnarl7107153un_snarl
unsocial1046073unsoci_al
until53517743unti__l
unusual743943unusual
unvocal1245233unvocal
unwind102610543unwin_d
unwinds11286733unwinds
urial54823023u_ri_al
urinals7610253u_rinals
vaccinal1544903vaccinal
vaginal11288403vaginal
veinal93812963_veinal
viminal12288823viminal
vinal85725813__vinal

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.423422437.4
2DLD Change Limit1340271456.43620824.6
3Display Results1451450.0632301.6
 (SQL Overall)1786911456.92225814.9
 
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.