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

435 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
insole6351586(None) 
indole74516051indole
insoles73516241insoles
anisole71010832anisole
anole55330382an_ole
cineole91010002cineole
console92715982console
ensile62616472ensile
income10712092income
indol63714872indol_
indoles83716362indoles
indols74714202indols
infold10128162infold
ingle64120432in_gle
inhale9411512inhale
inkle94515832in_kle
insane6314892insane
inshore1038722inshore
inside7613452inside
insolate8311892insolate
insolent81311552insolent
insoul638462insoul
insouled936112insouled
insouls737212insouls
insult62813672insult
insure63416602insure
intone61115432intone
invoke1336212invoke
involve1345092involve
inwove12167272inwove
isle45121702i_s_le
istle52214712i_stle
midsole1037812midsole
pinhole122010432pinhole
pinole83218782pin_ole
posole8314222posole
resole64624182resole
rissole739782rissole
sole46053672__sole
unsold71410512unsold
winsome1237462winsome
absolve1244513absolve
ainsell796393ainsell
airhole1048273airhole
aisle55223193ais_le
amole75724593_amole
ancone83916953ancone
anele55628833an_ele
angle64528873an_gle
anile54634463an_ile
anisoles81010123anisoles
ankle95220253an_kle
anode65021043an_ode
anoles64827433an_oles
ansae55720973ans_ae
ansate64517863ansate
anyone94612733anyone
areole61017283areole
asshole1046793asshole
azole145118033_azole
benzole1837133benzole
bindle94516263bin_dle
binocle1136493binocle
bole66448693__bole
bustle84015483bustle
cajole154011183cajole
castle84918963castle
cineol8108203cineol_
cineoles10109403cineoles
cineols9128853cineols
citole8311503citole
cole66956113__cole
condole102914953condole
consol82614113consol_
consoled112911453consoled
consoler102812613consoler
consoles103216153consoles
consols92914073consols
creole8913733creole
dhole95215363_dhole
diastole947563diastole
diazole1736793diazole
dindle84417223din_dle
dingle84317073din_gle
dipole91112853dipole
dissolve1246103dissolve
dole56550003__dole
enable83318483enable
encode9310443encode
encore8314773encore
enfold10137613enfold
enisle63412093enisle
ennoble935633ennoble
enol45823823en_ol_
enols54718403en_ols
enrobe86610793enrobe
enrol51014283enrol_
enroll61110073enroll
enrols61213383enrols
ensiled82611433ensiled
ensiles72714833ensiles
ensoul638253ensoul
ensouled935833ensouled
ensouls736033ensouls
ensue54013833ens_ue
ensure63416003ensure
finable122213623finable
finagle11238313finagle
finale94116763fin_ale
fissile10269653fissile
fusile94313493fusile
girasole984423girasole
gnome84213953gn_ome
haole84820083_haole
hassle93711593hassle
hirsle9159573hirs_le
hole77553393__hole
hustle93113993hustle
icicle1036583icicle
idle55423763i__dle
idol56818633i_dol_
idols65514133i_dols
ignoble1043613ignoble
ignore7269063ignore
impale102811663impale
impone103011863impone
impose103113053impose
inane52820343in_ane
inborn8319143inborn
inbye10427063in_bye
incage93513623incage
incase83615283incase
incise83515333incise
incite83618733incite
inclose9910223inclose
incog838253inco_g
incogs937903incogs
incomer1169943incomer
incomes11712373incomes
incony1139083incony
incult82414773incult
incuse83513573incuse
indene73215373indene
indie63721473in_die
indite73520323indite
indocile1146703indocile
indolent91311683indolent
indoor738403indoor
indorse8108193indorse
indow95011663indo_w
indowed1237443indowed
indows104210793indows
induce93811533induce
indue63516673in_due
indulge945403indulge
indult73614033indult
infall939403infall
infare9313083infare
infill938413infill
inflow1235293inflow
info75617353info__
infolded1375663infolded
infolder1256433infolder
infolds11137023infolds
inform11310153inform
infos84311673info_s
infuse93110573infuse
ingate73018243ingate
ingles74420873in_gles
ingot61221063ingo_t
ingoted939183ingoted
ingots7912063ingots
ingulf10310353ingulf
inhaled1169333inhaled
inhaler1068053inhaler
inhales10511863inhales
inhere9313713inhere
inholder1276113inholder
inhume1196583inhume
inion54620183inio_n
inions64417003inions
injure133410863injure
inkles103515653in_kles
inkstone1245413inkstone
inlace82513043inlace
inlet53732403in__let
inly75622213in__ly
inmate82917363inmate
inmost8411363inmost
innage73011573innage
innate63917313innate
innersole944333innersole
inosine7314283inosine
inosite7314063inosite
inpour837063inpour
inro45920793inro__
inroad737933inroad
ins35945603ins___
insaner7310443insaner
inscape1138023inscape
inscroll10113213inscroll
insculp1143793insculp
inseam8329993inseam
insect83916583insect
insert64325253insert
inset54430863ins_et
insets64016133insets
insider849733insider
insides8512653insides
insigne837673insigne
insist6314513insist
insnare748243insnare
insofar1043543insofar
insolated1039713insolated
insolates9311273insolates
insolence1147203insolence
insolents9137523insolents
insoluble1144243insoluble
insolvent12136123insolvent
inspan837513inspan
inspire938253inspire
instable10313203instable
instal6712193instal
install779363install
instals7611713instals
instar6310013instar
instate71616483instate
instep838193instep
instil61111383instil
instill789063instill
instils7811453instils
instroke1245583instroke
insular7138703insular
insulate8312843insulate
insulin738483insulin
insulted937193insulted
insulter836883insulter
insults7268963insults
insured83714253insured
insurer73312803insurer
insures73117263insures
intake10510863intake
intime81014273intime
intine61021983intine
intitle7610583intitle
into45026153into__
intomb1036403intomb
intoned8811993intoned
intoner7811673intoner
intones7816543intones
intort6418923intort
intown936153intown
inure54119053in_ure
inutile739883inutile
invade10157853invade
invite93715033invite
invoice12136243invoice
invoked1535303invoked
invoker1435363invoker
invokes1436383invokes
involute1145473involute
involved1534343involved
involver1444663involver
involves1444973involves
inwall938343inwall
inwoven13175523inwoven
ionone6313443ionone
irksome1344373irksome
irone55126363i_rone
isled64615993i_s_led
isles54220563i_s_les
islet54527553i_s_let
isohel935483i_sohel
isolate7313923i_solate
isolead835183i_solead
isoline7314013i_soline
isolog737403i_solog
isomer8310153i_somer
issue559213i_ssue
istles62814983i_stles
itself946263itself
ixtle12168013i_xtle
jingle143815223jin_gle
jole117233823__jole
jostle13319863jostle
justle133211583justle
kindle114414233kin_dle
kinfolk1363603kinfolk
kinsfolk1442003kinsfolk
knoll9389603kn_oll
linable92214343linable
lintol6369473lintol_
lintols7339553lintols
lisle53916723lis_le
lissome937583lissome
manhole12311343manhole
midsoles1137763midsoles
minable112315073minable
mingle93518783min_gle
missile92815403missile
mole66251833__mole
muscle10310973muscle
nestle63013953nestle
nibble103713283nibble
nickle123814483nickle
nicol71113293nicol_
nicols8810243nicols
niggle83612823niggle
nimble103412943nimble
nipple103410373nipple
noble74420993_noble
node513036883_n_ode
noel45226553_n_oel
nolo46229313_n_olo
nome66038423_n_ome
none45743173_n_one
noodle73212543_noodle
noose55624063_noose
nope65934193_n_ope
nose46739363_n_ose
note46239963_n_ote
obole75917143_obole
oilhole1046263oilhole
ole37155213___ole
onshore10310013onshore
onside7511803onside
oriole6814293oriole
osmole8128513osmole
outsole71013433outsole
parole84425253parole
pensile92713543pensile
pestle83215843pestle
piehole12188553piehole
pinbone1138183pinbone
pinfold1336233pinfold
pinholes131810663pinholes
pinnule936003pinnule
pinocle1138143pinocle
pinoles93418703pin_oles
pintle83818263pin_tle
pinwale1257843pinwale
pistole92414313pistole
plimsole1243663plimsole
pole65951303__pole
posoles9314883posoles
pozole1758913pozole
prole74527793_prole
psoae74411623_psoae
rassle63813203rassle
resale64025543resale
resile64627673resile
resold73915363resold
resoled84119283resoled
resoles73823653resoles
resolve103910983resolve
rinsable10310043rinsable
rinse54820973rins__e
rinsible1046293rinsible
rissoles839113rissoles
role45851823__role
rustle63615413rustle
sale44959703__sale
single74520603sin_gle
sinkhole1594383sinkhole
sinsyne1043303sinsyne
slipsole1044263slipsole
sloe45534953__sloe
snool55118643snool_
snooled84513943snooled
snools65715883snools
snooze15439993snooze
snoozle16305913snoozle
snore55424953sn_ore
socle7419573__socle
soke85436263__soke
sol37256623__sol_
sola45541863__sola
sold54837413__sold
soled65835173__soled
solei55624343__solei
soles55547923__soles
soli46637013__soli
solo45538943__solo
sols45448163__sols
solve85618943__solve
some66040383__some
sone46649983__sone
sore47059533__sore
stole54928813_stole
systole1035763systole
tensile72612733tensile
thole85620843_thole
tingle74319063tin_gle
tinkle103714453tin_kle
tinsel639443tinsel_
tinseled935763tinseled
tinsels738373tinsels
tinstone848173tinstone
tole46052903__tole
turnsole844693turnsole
tussle637143tussle
ugsome934783ugsome
unable83819223unable
unbale83616403unbale
unbolt83013893unbolt
uncle7317053un_cle
undone7914253undone
unfold10179703unfold
unholy1238163unholy
unmold9148313unmold
unpile81914323unpile
unrobe82611673unrobe
unroll61210073unroll
unrove92511683unrove
unsafe9310693unsafe
unsell63512543unsell
unsober967643unsober
unsoiled92412083unsoiled
unsolder937213unsolder
unsolid8138373unsolid
unsolved1237833unsolved
unsowed112511053unsowed
unsown9328433unsown
unspoke1336573unspoke
unsure62815413unsure
unswore1039053unswore
untold7149683untold
unwove12238883unwove
unyoke1367293unyoke
vole75236983__vole
whole114418093_whole
windle104617953win_dle
winkle133812833win_kle
winsomer1345773winsomer
wintle94014603win_tle

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164355.51620434.4
3Display Results4354350.1562788.5
 (SQL Overall)1786914356.06229477.2
 
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.