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

119 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
encinal94925(None) 
encina8310441encina_
encinas938721encinas
uncinal959961uncinal
anconal939422anconal
anginal8310162anginal
dentinal939502dentinal
incisal947382incisal
uncial83715222unci_al
vicinal12268542vicinal
acinar8310483_acinar
actinal9312293actinal
aecial84817313aeci_al
affinal1336443affinal
albinal937813albinal
ancilla948603ancilla
anconeal1045593anconeal
angina7413133angina_
anginas8310953anginas
animal85016253an_imal
annal56520763an__nal
basinal9310033basinal
binal75323823__binal
canal75428043__canal
carinal94318243carinal
clinal8311553_clinal
decanal1038113decanal
decimal1238083decimal
deicidal1245713deicidal
denial74720513den_i_al
denominal1245693denominal
duncical1345213duncical
ecocidal1354963ecocidal
edictal1046993edictal
enceinte1046263enceinte
enchant12313133enchant
encircle1243943encircle
ending83220253endin_g
endings92910443endings
engine71114863engin_e
engined9119893engined
engines81114463engines
enkindle1363163enkindle
ensnarl784913en_snarl
enteral73516453enteral
enthral103410933enthral
entia5318203enti_a_
enwind10298083enwin_d
enwinds11255553enwinds
epical10413393e_pical
espial839543espi_al
estival1036323estival
eternal72910893eternal
ethical1238443ethical
ethinyl1343433ethinyl
facial113615633faci_al
fecial114714623feci_al
fencing132411133fencin_g
fencings14225663fencings
final83922033__final
geminal10109913geminal
genial74917613gen_i_al
genital849793gen_ital
genocidal1343913genocidal
germinal1147263germinal
incivil1244933incivil
incudal1045873incudal
inguinal945603inguinal
intimal9109943intimal
invital1046953invital
lacunal9136553lacunal
laminal94113633laminal
liminal93810673liminal
luminal93711003luminal
matinal9312603matinal
medicinal1445083medicinal
menial84223033men_i_al
nidal65217113_n_idal
nival84915773_n_ival
nominal92712373nominal
nonfinal1147703nonfinal
nounal639813_nounal
orcinol944703orcinol
ordinal838643ordinal
paginal10269493paginal
pencil103712973penci__l
penial84120893pen_i_al
piscinal1285843piscinal
racial83419243raci_al
recital9412173recital
reginal84814293reginal
retinal75318353retinal
rhinal9510203_rhinal
ruminal9289993ruminal
seconal9310073seconal
seminal91213413seminal
sentinel838703sentinel
social8813333soci_al
spinal84915313_spinal
synclinal1443103synclinal
tegminal1144453tegminal
tensional946213tensional
terminal1039733terminal
trinal6516963_trinal
uncia75015163unci_a_
unciae83215313unci_ae
uncials92510523unci_als
uncinate10312393uncinate
uncini8310153uncin_i
uncinus937403uncinus
uncivil1244793uncivil
urinal6614123_urinal
vaccinal1544903vaccinal
vaginal11288403vaginal
veinal93812963_veinal
venial94218283ven_i_al
viminal12288823viminal
vinal85725813__vinal
xenial133414903xen_i_al

Search took 8 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 Limit1340271197.09318895.7
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.54523683.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.