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

312 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
instal671219(None) 
install779361install
instals7611711instals
instar6310011instar
instil61111381instil
costal85419512costal
distal73615772distal
festal94213562festal
initial7311882initial
inseam8329992inseam
insoul638462insoul
inspan837512inspan
instable10313202instable
installs858922installs
instant7815352instant
instars7411132instars
instate71616482instate
instead836202instead
instep838192instep
instill789062instill
instils7811452instils
invital1046952invital
natal53921492_natal
notal55221352_notal
postal84317532postal
unseal63315472unseal
vestal94615572vestal
acetal84314903acetal
ainsell796393ainsell
anal48037523an__al
animal85016253animal
annal56520763an_nal
anneal64812293anneal
annual64710703annual
anodal72512123anodal
ansa45927773ans_a_
ansae55720973ans_ae
ansate64517863ansate
anta46839583an_ta_
antae56828293an_tae
antas55432033an_tas
antral65719413antral
anural65714743anural
aortal65217513aortal
artal55525473_artal
astral66919283_astral
austral73411513austral
basal75722283bas_al
bestial9311643bestial
bimetal1138433bimetal
binal75323823bin__al
borstal939043borstal
brutal859383brutal
byssal1134993byssal
cantal84122033cantal
casual81112863casual
censual937663censual
cental84420963cental
cesta75419483cesta_
cestas85018543cestas
chital114313883chital
coastal9411043coastal
coital84117053coital
costa75523733costa_
costae85319683costae
costar85518613costar
crestal9312133crestal
crustal939023crustal
crystal1237433crystal
curtal83914543curtal
cuspal1037883cuspal
dental74319173dental
diastral946993diastral
digital937063digital
dismal92412243dismal
distil73616433distil
dossal75510303dossal
dotal64919623_dotal
ductal938993ductal
ensnarl784913ensnarl
ensoul638253ensoul
entail61114343en_tail
estral64716513_estral
fatal84819373_fatal
fetal85623373_fetal
fiesta938123fiesta_
fiestas1038433fiestas
final83922033fin__al
finial92814183fin_ial
finical1239693finical
fiscal1139333fiscal
foetal9311883foetal
fontal9313143fontal
gastral8329553gastral
genital849793genital
gestalt8411173gestalt
gingal81010153gin_gal
gnathal1144353gnathal
hartal9415473hartal
hiatal9310203hiatal
hosta85917833hosta_
hostas94515833hostas
hostel93914153hostel
hyetal1236543hyetal
ideal65716393i_deal
ileal56118083i_leal
ilial55317843i_lial
incisal947373incisal
incudal1045863incudal
indol63714873in_dol
indusial966643indusial
inertial8411723inertial
infall939403infall
infill938413infill
infra838643infra_
ingate73018243ingate
ingesta8357863ingesta_
inhale9411513in_hale
inhaul936803inhaul
inia45024703in_ia_
initials848103initials
inkstand1343803inkstand
inlay85214323in_lay
inmate82917363inmate
innate63917313innate
inositol843983inositol
inroad737933inroad
ins35945603ins___
insane6314893insane
inscape1138023inscape
insculp1143793insculp
inseams9307903inseams
insect83916583insect
insectan1045393insectan
insert64325253insert
inset54430863ins_et
insets64016133insets
inside7613453inside
insist6314513insist
insnare748243insnare
insofar1043543insofar
insole63515863insole
insouls737213insouls
inspans937803inspans
installed1045853installed
installer945013installer
instance1049883instance
instancy1346573instancy
instantly1256013instantly
instants8910153instants
instated91613343instated
instates81615833instates
insteps936573insteps
instills867353instills
insular7138703insular
insult62813673insult
insure63416603insure
intact8314663in_tact
intagli845023in_tagli
intake10510863in_take
inter55028493in_ter
inthral10249463inthral
inti46626083in_t_i
intimal9109943intimal
intis55121643in_tis
into45026153in_t_o
intro54915853in_tro
inutile739883inutile
invar839513in_var
inwall938343inwall
inwrap11115903inwrap
iota45127833i_ota_
iotas54821113i_otas
irreal657833irreal
isba61310883i_sba_
isbas71010403i_sbas
istle52214713i_stle
jingal1498593jin_gal
kinsman1335963kinsman
lanital7310913lanital
lineal65616023lin_eal
lingual8379083lingual
lintel64013993lin_tel
lintol6369473lin_tol
listel64214743listel
lustral7339653lustral
mainstay1344033mainstay
meatal84114733meatal
mensal84615663mens_al
mental84521603mental
mescal104113493mescal
mesial84818083mesial
metal75427383_metal
miasmal1176743miasmal
mineral9312733mineral
minimal114010603minimal
minster93914323minster
minstrel1046913minstrel
minutial1046423minutial
miskal123710263miskal
missal84314903missal
mistral91013643mistral
mortal84616853mortal
nasal56217593_nasal
nasial6413283nasial
naval85315833_naval
nidal65217103_nidal
nival84915773_nival
nodal64717793_nodal
nopal75517103_nopal
nota46830773_nota_
octal71214723_octal
onstage838363onstage
osteal6312963_osteal
pascal10812373pascal
pasta76624533pasta_
pastas85422873pastas
pastel85918713pastel
pastil85018323pastil
petal76526893_petal
pinata83817223pinata_
pinatas93711503pinatas
pineal84817683pin_eal
pineta85815563pineta_
pinitol936683pinitol
pinnal84814273pin_nal
pinta75727053pin_ta_
pintail9311183pin_tail
pintas85021393pin_tas
pistil83915073pistil
pistol83313333pistol
pivotal1245433pivotal
portal84218463portal
postals93716383postals
qintar15359143qin_tar
quintal16389883quin_tal
rascal8511123rascal
ratal55025113_ratal
rectal84418133rectal
reinstall944563reinstall
rental63922023rental
reseal64819643reseal
rictal83113183rictal
ringtail944723ringtail
ringtaw1154363ringtaw
rostral7311333rostral
sal36462883__s_al
seal45654373__seal
sensual738053sensual
septal84513383septal
setal56430903_setal
sial45938833__sial
siesta639503siesta_
siestas738813siestas
sinistral944683sinistral
sisal54217733sis_al
spital83813873spital
stab67329933__stab
stag57332003__stag
stale55637103__stale
stalk94518003__stalk
stall54722353__stall
star48037763__star
stat47352693__stat
statal61613223statal
staw78627693__staw
stay78333723__stay
steal56125473__steal
tectal83713253tectal
testa54822043testa_
testae64216253testae
tincal83913363tin_cal
tineal66216163tin_eal
tinsel639443tins_el
tissual745193tissual
total55321823_total
tussal6288323tussal
uncial83715223uncial
ungual738183ungual
uninstall953203uninstall
unreal64414453unreal
unsay83212843uns_ay
unseals73212583unseals
unseam83313143unseam
unseat64221023unseat
unsell63512543unsell
unsnag736393unsnag
unsnap836203unsnap
unsnarl7107153unsnarl
unstable10313763unstable
unstably1339493unstably
unstack1337373unstack
unstate71916213unstate
unsteel738793unsteel
unstep839223unstep
unstop837473unstop
unstrap946783unstrap
until53517743un_til
unusual743943unusual
usual5310183_usual
vasal85516293vas_al
vassal979243vassal
vesta86618303vesta_
vestals104612333vestals
vestas95916683vestas
vestral104111013vestral
vinal85725813vin__al
vineal94814743vin_eal
vista85416603vista_
vistas94513273vistas
visual938803visual
vital84819673_vital

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 Limit1127163125.11022057.9
3Display Results3123120.1102836.4
 (SQL Overall)1786913125.59331949.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.