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

400 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
enisle6341209(None) 
enisled82510221enisled
enisles72312601enisles
ensile62616471ensile
aisle55223192_aisle
anile54634462ani_le
anise55129702anis_e
anisole71010832anisole
edible969352edible
edile64819492edi_le
enable83318482enable
ensiled82611432ensiled
ensiles72714832ensiles
ensue54013832en_sue
entitle7610292entitle
epistle957892epistle
exile126117652exi_le
isle45121702__isle
lisle53916722_lisle
penile82219602peni_le
pensile92713542pensile
senile63420212seni_le
tensile72612732tensile
aedile73716653aedi_le
agile65122263agi_le
aisled74516183_aisled
aisles64721143_aisles
alible8311973alible
anele55628833an_ele
angle64528873an_gle
anil46437433ani_l_
anils56326723ani_ls
anime75423203ani_me
anis45746463anis__
aniseed839403aniseed
anises64826693anises
anisic8313793anisic
anisoles81010123anisoles
ankle95220253an_kle
anole55330383an_ole
ansae55720973an_sae
arise56436433aris_e
axile126020513axi_le
benison937123benison
benzole1837133benzole
bernicle1245443bernicle
betise85616273betis_e
bible95119423_bible
bile66147183_bi_le
bindle94516263bindle
birle75023633_birle
bise66437103_bis_e
bridle94115463bridle
bristle91910103bristle
cenacle1139123cenacle
cense75121403cen_s_e
centile94217183centile
cerise84822043ceris_e
chenille1354593chenille
chicle134312543chicle
chile105626893chi_le
chisel112111943chisel
cnidae978143cnidae
cuisse8318333cuisse
decile94619213deci_le
defile105216663defi_le
dehisce13104273dehisce
demise94618323demis_e
deniable11312083deniable
denial74720513denial_
denials84114133denials
dense65923503den_s_e
denticle1137773denticle
devise104215753devis_e
devisee113812713devisee
dindle84417223dindle
dingle84317073dingle
disme85716243_disme
eagle64219483e_agle
ease45042333e_as_e
easel54521113e_asel
easily9313023easily
ebonise939613ebonis_e
edibles1048003edibles
ediles74016983edi_les
egis56520653egis__
egises7312493egises
eide55832243e_i_de
ekuele1034383ekuele
elide64922643eli_de
elite56230183eli_te
else45923083e_ls_e
emigre937053emigre
empale102611263empale
enabled102510633enabled
enabler9299363enabler
enables92813123enables
enamel81210113enamel
enate54428153en_ate
encage93713503encage
encase83714363encase
encircle1243943encircle
encode9310443encode
encore8314773encore
endite73817593endite
endive103310473endive
ends56528523ends__
endue64215353en_due
endure74014143endure
endwise1136463endwis_e
enface112510353enface
enfold10137613enfold
engage82812103engage
engild8107613engild
engine71114863engine
engirdle1043223engirdle
engs56121393engs__
engulf1038883engulf
enhalo987563enhalo
enigma935643enigma
enisling949633enisling
enkindle1363163enkindle
enlace82213233enlace
enlist6417043enlis_t
enlisted978193enlisted
enlistee868323enlistee
enlister847803enlister
enlists749393enlists
ennoble935633ennoble
ennuye973753ennuye
enol45823823en_ol_
enols54718403en_ols
enosis63816423enosis
enrage72715073enrage
enrobe86610793enrobe
enrol51014283enrol_
enroll61110073enroll
enrols61213383enrols
ens37245923en_s__
ensign737523ensign
ensilage944713ensilage
ensky1235093en_sky
enslave1036273en_slave
ensued73610483en_sued
ensues63313813en_sues
ensure63416003ensure
entice81316863entice
entire61617703entire
entitled967503entitled
entitles8710663entitles
entree61817883entree
enure53520223en_ure
enviable1337853enviable
envisage1242653envisage
enzyme2054343enzyme
eonism83213533eonis_m
eonisms92811043eonisms
eosine64519413eosine
episode1056303episode
episome1157813episome
epistler1044833epistler
epistles1047783epistles
epistyle1364073epistyle
erase54925493eras_e
erose55727273eros_e
esne47018793e__sne
etoile6312263etoile
evil75318073evi_l_
eviler94811893evi_ler
eviller1056673eviller
evilly1236593evilly
evils84114263evi_ls
evince1137763evince
evite85317683evi_te
evulse935213evulse
exciple1874683exciple
excise1538553excis_e
exhale1636873exhale
exiled144712463exi_led
exiler134712183exi_ler
exiles134816403exi_les
exine125518493exi_ne
exist124618943exis_t
existed1538473existed
exists134710913exists
faille93414743faille
fenagle11197153fenagle
fencible1545603fencible
file75446643_fi_le
fille84327403_fille
finale94116763finale
foible11410383foible
frise85322453fris_e
frisee94217993frisee
funicle12237483funicle
fusile94313493fusile
genial74917613genial_
genie66124923geni__e
genoise839423genois_e
gentile83515293gentile
gentle74014513gen_tle
grille74315743grille
grilse7399503grilse
grisly104310583grisly
gristle8169223gristle
guile64521133gui_le
guise64717713guis_e
hassle93711593hassle
hirsle9159573hirsle
hoise85224773hois_e
icicle1036583icicle
idle55423763__idle
incise83515333incis_e
indole74516053indole
ingle64120433in_gle
inhale9411513inhale
inkle94515833in_kle
inside7613453inside
insole63515863insole
intitle7610583intitle
ionise63516943ionis_e
isled64615993__isled
isles54220563__isles
islet54527553__islet
istle52214713__istle
jingle143815223jingle
kindle114414233kindle
knife1210010133kni_fe
knish1238603knis_h
knishes1438263knishes
legible1035833legible
lenis56326863lenis__
lenite6719983leni_te
lense54523433len_s_e
lisles63416283_lisles
maile75232223mai_le
manille92613273manille
maniple11249653maniple
measle83513223measle
meikle1236653meikle
menial84223033menial_
menials94015683menials
menisci1144783menisci
mensae84114053men_sae
mense75025633men_s_e
metisse936503metisse
mile66352573_mi_le
mille75029133_mille
mingle93518783mingle
mise66043583_mis_e
misled94719313_misled
mislie83219153_mislie
nebule848753nebule
needle73310613needle
neist54628443neis_t
nestle63013953nestle
nettle64514583nettle
newsie9138213newsie
nibble103713283_nibble
nice65534713_ni_ce
niche105016793_niche
nickle123814483_nickle
nide55535793_ni_de
niece74814503_niece
nieve85613183_nieve
niggle83612823_niggle
nil36144193_ni_l_
nill45634303_ni_ll
nilled73919453_nilled
nills54926673_nills
nils46132453_ni_ls
nimble103412943_nimble
nine45842173_ni_ne
nipple103410373_nipple
nisei54214353_nisei
nisi45823243_nis_i
nisus56014393_nisus
nite45943583_ni_te
nitre57519683_nitre
nixe115722023_ni_xe
nixie125114943_nixie
noble74420993_noble
noise55723733nois_e
nose46739363_nos_e
onside7511803onside
oriole6814293oriole
paise75028333pais_e
paisley1235553paisley
panicle11129983panicle
pedicle1238973pedicle
peise75825773peis_e
pelisse967063pelisse
penial84120893penial_
penis75129323penis__
penises9318193penises
pensee8417313pen_see
pensil83013333pensil_
pensils92811593pensils
pensive122610393pensive
petiole9311303petiole
pile65649693_pi_le
pinole83218783pinole
pintle83818263pintle
piste75824603_piste
plisse8368403plisse
poise75127893pois_e
prise74632613pris_e
puisne856353puisne
raise54828053rais_e
rassle63813203rassle
refile95122373refi_le
remise84221953remis_e
rendible11128353rendible
rerise64325633reris_e
resile64627673resi_le
reticle94112623reticle
retile65929673reti_le
retitle73913093retitle
revile94921613revi_le
revise94019743revis_e
rifle85518333_rifle
rile45650533_ri_le
rille55728733_rille
rinse54820973rins_e
rise45945233_ris_e
sanicle91210263sanicle
sedile73517233sedi_le
seise54727853seis_e
seniles72618023seni_les
sense55526823sen_s_e
sensible1037853sensible
sessile739523sessile
sidle65124033_sidle
single74520603single
smile74823923smi_le
snide64318723sni_de
sniffle13287653sniffle
sniggle9316833sniggle
sniglet83612413sniglet
snipe75320573sni_pe
snivel9368853snivel
spile75230083spi_le
stifle93611903stifle
stile54931573sti_le
swiple11379233swiple
taille63116923taille
tenable93214493tenable
tenaille846813tenaille
teniae64517353teni_ae
tense55225843ten_s_e
tensible1037243tensible
tensive10269913tensive
thistle10107803thistle
tile45451443_ti_le
tingle74319063tingle
tinkle103714453tinkle
tinsel639443tinsel
title54721073_title
toile54626493toi_le
tousle64514653tousle
trifle94012883trifle
triple84215923triple
triste63818643triste
tuille63012643tuille
tunicle9308033tunicle
tussle637143tussle
unable83819223unable
unbale83616403unbale
uncle7317053un_cle
unique1558163unique
unisex1358353unisex
unisize1647343unisize
unison649033unison
unite54828383uni_te
unpile81914323unpile
unwise9510803unwis_e
utile54718933uti_le
vehicle15175253vehicle
veinule1056243veinule
vendible14156473vendible
venial94218283venial_
venine93718433veni_ne
venire93513693veni_re
venison1036443venison
venose9310843venos_e
venule94411763ven_ule
vernicle1346433vernicle
vesicle12217923vesicle
vile76139803_vi_le
vise75632673_vis_e
voile84719723voi_le
warsle93112923warsle
while115418693whi_le
whistle13107533whistle
wile75944373_wi_le
windle104617953windle
winkle133812833winkle
wintle94014603wintle
wise75737343_wis_e
xenial133414903xenial_

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.406440125.6
2DLD Change Limit1127164005.42020796.3
3Display Results4004000.1263174.6
 (SQL Overall)1786914005.95230022.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.