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

136 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
initial731188(None) 
initials848101initials
inertial8411722inertial
inimical1247312inimical
initialed1065352initialed
initialer964612initialer
initially1249062initially
initiate8412692initiate
instal6712192inst_al
instil61111382insti_l
instill789062instill
intimal9109942intimal
invital1046952invit_al
minutial1046422minutial
animal85016253ani_mal
antiar6317173an_tiar
antral65719413an_tral
bestial9311643bestial
binomial1246223binomial
chital114313883chit_al
citral81113893_citral
coital84117053coit_al
comitial1248693comitial
conidial1159503conidial
critical12310263critical
digital937063digit_al
entail61114343en_tail
entia5318203en_tia_
fetial95716193_fetial
filial93013253_filial
finial92814183_finial
finical1239693fini_cal
genital849793genit_al
genitival1343293genitival
gnathal1144353gnathal
gonidial1065943gonidial
idiotical1244793idiotical
ignatia846133ignatia_
ignatias944913ignatias
ignitible1243163ignitible
igniting1037363igniting
ignition946533ignition
ilial55317843__ilial
incisal947373incisal
inciting11312533inciting
incivil1244933incivi_l
incudal1045863incudal
indicia1046983indicia_
indicias1147413indicias
inditing10312113inditing
indusial966643indusial
inertia7410203inertia_
inertiae8411473inertiae
inertias8410383inertias
infill938413in_fill
inguinal945603inguinal
inia45024703in__ia_
initialers1053043initialers
initialing1145883initialing
initialism1257213initialism
initialize1996863initialize
initialled1162953initialled
initiated10510113initiated
initiates9411183initiates
initiator998113initiator
install779363install
instals7611713inst_als
instar6310013inst_ar
instead836203instead
instills867353instills
instils7811453instils
inthral10249463inthral
inti46626083in_ti__
intima81910033in_tima
intimae9109753intimae
intimas9119583intimas
intime81014273in_time
intine61021983in_tine
intis55121643in_ti_s
intitle7610583in_title
inutile739883inutile
inviting1239733inviting
iritic83213823iriti_c
iritis63113733iriti_s
ischial1246423ischial
lanital7310913lanit_al
lixivial1842943lixivial
lunitidal1043183lunitidal
martial92415413martial
militia949733militia_
militias1048633militias
minimal114010603mini_mal
minimill1244483minimill
minipill1244353minipill
minutia946423minutia_
minutiae1045593minutiae
mitral81314323_mitral
narial6317953_narial
nasial6413283_nasial
natal53921493_nat_al
nidal65217103_ni_dal
nihil8410283_nihi_l
nitid61817833_niti_d
nitinol745143_nitinol
nitril62511533_nitril
nival84915773_ni_val
noninitial1056913noninitial
notal55221353_not_al
nuptial946633nuptial
partial92616263partial
pinitol936683pinit_ol
pintail9311183pin_tail
retial64724993_retial
ringtail944723ringtail
ritual6310623_ritual
sinistral944683sinistral
spatial9310323spatial
spital83813873spit_al
stibial946583stibial
tertial7313863tertial
tibial849843_tibial
titian62512663_titian
trivial1038713trivial
uncial83715223un_cial
unfilial1145343unfilial
uniaxial1543883uniaxial
unideal837103unideal
unities72520153unities
uniting8315823uniting
unitive10310563unitive
unitize16310033unitize
until53517743un_ti_l
vital84819673_vit_al
vizirial2043473vizirial
withal1238933_withal
zenithal2093333zenithal

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.1401276364.3
2DLD Change Limit1340271366.73319906.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911366.91925826.1
 
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.