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

144 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
anisole7101083(None) 
anisoles81010121anisoles
aisle55223192a_is_le
anile54634462ani__le
anise55129702anis__e
anole55330382an__ole
antipole10910152antipole
camisole1246172camisole
enisle63412092enis_le
insole63515862in_sole
absolve1244513a_bsolve
acinose938583acinose
adipose1036653adipose
agile65122263agi__le
ainsell796393ainsell
aioli5318313a_i_oli
airhole1048273airhole
aisled74516183a_is_led
aisles64721143a_is_les
alible8311973ali_ble
amiable11312033amiable
amidol9489573amidol_
amidols10457563amidols
amidone10349313amidone
amitrole1045173amitrole
amniote936963amni_ote
amole75724593a__mole
anagoge9166643anagoge
ancone83916953an_cone
anele55628833an__ele
anemone9119453anemone
anethole1146253anethole
anginose945903anginose
angle64528873an__gle
anil46437433ani__l_
aniline7418473aniline
anils56326723ani__ls
animal85016253animal_
animals94111703animals
animate91617213animate
anime75423203ani__me
anion55028813ani_o_n
anions64123033ani_ons
anis45746463anis___
aniseed839403aniseed
anises64826693anis_es
anisette846773anisette
anisic8313793anis_ic
ankle95220253an__kle
anode65021043an__ode
anoles64827433an__oles
ansae55720973an_s_ae
ansate64517863an_sate
anticold1147473anticold
antidote949723antidote
antimale10312463antimale
antinode9810233antinode
antinome10810443antinome
antipode1199283antipode
antipoles11810473antipoles
antipope1268133antipope
antiroll847763antiroll
antismoke1544503antismoke
antisolar9116753antisolar
antistyle1244603antistyle
anymore1256243anymore
anyone94612733an_yone
apishly1535663apishly
apostle937853apostle
areole61017283a_reole
ariose64818723ari_ose
arise56436433aris__e
aristae7312533aristae
armhole1236943armhole
asshole1046793asshole
atingle848253atingle
aureole738693aureole
aviso85713963aviso__
avisos95410483aviso_s
awesome1245573awesome
axile126020513axi__le
azole145118033a__zole
bricole112810493bricole
bristle91910103bristle
camisoles1345583camisoles
canistel10187253canistel
cariole9818343cari_ole
cineole91010003cineole
citole8311503_citole
console92715983console
dariole8711163dari_ole
dipole91112853_dipole
enisled82510223enis_led
enisles72312603enis_les
ensile62616473en_sile
episode1056303episode
episome1157813episome
epistle957893epistle
frijole1734583frijole
gristle8169223gristle
handsome1447603handsome
indole74516053in_dole
insoles73516243in_soles
isle45121703__is_le
istle52214713__istle
lisle53916723_lis_le
manhole12311343man_hole
manifold1484943manifold
manille92613273mani_lle
maniple11249653mani_ple
midsole1037813midsole
nestle63013953_nestle
nibble103713283_nibble
nickle123814483_nickle
nicol71113293_nicol_
nicols8810243_nicols
niggle83612823_niggle
nimble103412943_nimble
nipple103410373_nipple
noisome947973noisome
oriole6814293ori_ole
outsole71013433outsole
panicle11129983pani_cle
pinhole122010433pinhole
pinole83218783_pinole
pistole92414313_pistole
plimsole1243663plimsole
posole8314223_posole
resole64624183_resole
rissole739783rissole
sanicle91210263sani_cle
slipsole1044263slipsole
sniffle13287653sniffle
sniggle9316833sniggle
sole46053673___sole
thistle10107803thistle
trisome9310223trisome
unisize1647343unisize
unison649033uniso_n
unisons748423unisons
unsold71410513un_sold
variole10711593vari_ole
whistle13107533whistle
winsome1237463winsome

Search took 8 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.406440125.6
2DLD Change Limit1340271447.00019146.7
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.45223978.9
 
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.