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

218 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
instil6111138(None) 
instal6712191instal
instill789061instill
instils7811451instils
distil73616432distil
initial7311882initial
insoul638462insoul
install779362install
instals7611712instals
instar6310012instar
instep838192instep
instills867352instills
inti46626082in_ti_
intis55121642in_tis
inutile739882inutile
pastil85018322pastil
pistil83915072pistil
until53517742un_til
abseil837183abseil
ainsell796393ainsell
anil46437433an__il
anti45536363an_ti_
antic75728863an_tic
antis55033313an_tis
anvil82712603an_vil
apostil947903apostil
assail6610153assail
assoil688543assoil
astir55517093_astir
basil75122273bas_il
bastile9313913bastile
bestial9311643bestial
bestir8311163bestir
bustic101012693bustic
cesti75217423cesti_
costal85419513costal
cystic132710653cystic
dentil74017883dentil
distal73615773distal
distill83011323distill
distils83015803distils
dossil75110903dossil
dustily113211523dustily
einstein844183einstein
enatic8317563enatic
ensile62616473ens_ile
ensoul638253ensoul
entail61114343entail
entia5318203en_tia
entoil6912493entoil
festal94213563festal
fistic11812573fistic
fossil9379353fossil
fusil84715323fus_il
fustic11910633fustic
fustily133111373fustily
gentil74115123gentil
gestic9312773gestic
gnostic1038433gnostic
gustily113010903gustily
hastily133010663hastily
hostel93914153hostel
hostile10312553hostile
ictic9311803i_ctic
ignatia846133ignatia
inbuilt947323inbuilt
incite83618733incite
incivil1244933incivil
inclip1036823inclip
indie63721473in_die
indite73520323indite
indol63714873in_dol
indri6310793indri_
indris7311963indris
inertia7410203inertia
inertial8411723inertial
infall939403infall
infill938413infill
infix15337773in_fix
inhaul936803inhaul
inia45024703in__ia
initials848103initials
inlaid7310143inlaid
inosite7314063inosite
inositol843983inositol
ins35945603ins___
insane6314893insane
insculp1143793insculp
inseam8329993inseam
insect83916583insect
insectile1147113insectile
insert64325253insert
inset54430863ins_et
insets64016133insets
inside7613453inside
insipid1044513insipid
insist6314513insist
insole63515863insole
insouls737213insouls
inspan837513inspan
inspire938253inspire
instable10313203instable
installs858923installs
instant7815353instant
instars7411133instars
instate71616483instate
instead836203instead
insteps936573insteps
instilled1045303instilled
instiller944953instiller
instinct1048723instinct
insulin738483insulin
insult62813673insult
insure63416603insure
inter55028493in_ter
intima81910033in_tima
intimal9109943in_timal
intime81014273in_time
intine61021983in_tine
intitle7610583in_title
into45026153in_t_o
intro54915853in_tro
intuit6314083intuit
inulin6311733inulin
invital1046953invital
invite93715033invite
inwall938343inwall
iritic83213823iritic
iritis63113733iritis
isatin6412213isatin
issei568573issei_
isseis638563isseis
istle52214713i_stle
kinetic13209173kinetic
kinetin11248263kinetin
kinship1645833kinship
lentil64315393lentil
lintel64013993lin_tel
lintol6369473lin_tol
listel64214743listel
lustily103611243lustily
mainsail1045173mainsail
mastic103119173mastic
mastix152310513mastix
minster93914323minster
minstrel1046913minstrel
minutia946423minutia
minutial1046423minutial
mistily122612343mistily
mustily123613633mustily
mystic132711643mystic
nail45838653_n_ail
nastic82915973nastic
nastily103011033nastily
natal53921493_natal
niftily1335753niftily
nihil8410283_nihil
nil36144193_n__il
nisei54214353nisei_
niseis63512023niseis
nisi45823243nis_i_
nitid61817833_nitid
nitril62511533nitril
noil46133243_n_oil
nostril749303nostril
notal55221353_notal
ontic74418573on_tic
ostia52315583_ostia
pastel85918713pastel
pastie85525523pastie
pastils94416173pastils
pastis84924323pastis
pensil83013333pens_il
pinitol936683pinitol
pintail9311183pintail
pistils93314303pistils
pistol83313333pistol
pontil8315463pontil
postal84317533postal
postie84123963postie
postin83521033postin
ramtil8311033ramtil
resail64418733resail
ringtail944723ringtail
rustic8712673rustic
rustily103112993rustily
sail45447163__sail
snail57020203sn_ail
soil46138833__soil
stile54931573__stile
still54922083__still
stilt54831983__stilt
stir45723253__stir
tastily103311643tastily
testily102910803testily
testis64916713testis
til36350263___til
tinfoil1044633tinfoil
tinsel639443tins_el
tonsil6311873tons_il
uncoil8811853uncoil
unnail6410583unnail
unsaid7411833unsaid
unseal63315473unseal
unsell63512543unsell
unship1148033unship
unspilt938853unspilt
unsteel738793unsteel
unstep839223unstep
unstick1338123unstick
unstop837473unstop
untie54425493un_tie
unveil957343unveil
upstir835383upstir
vestal94615573vestal
wingtip1343613wingtip
xysti15538153xysti_
zestily19167563zestily

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162185.40620850.2
3Display Results2182180.0932344.1
 (SQL Overall)1786912185.87230431.0
 
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.