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 “anole” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
anole5533038(None) 
amole75724591amole
anele55628831anele
angle64528871angle
anile54634461anile
ankle95220251ankle
anode65021041anode
anoles64827431anoles
azole145118031azole
abele76323252abele
able66340532a_ble
abode85518812abode
above105414322above
acnode938202acnode
acold86214932acold
addle74318352addle
adobe84814712adobe
adore65723672adore
adoze155713832adoze
afore85818602afore
agile65122262agile
agone65924552agone
ahold94714252ahold
aioli5318312aioli
aisle55223192aisle
ale36572342a__le
aloe45540192alo_e
alone55732962alone
amble95924642amble
amoles84122192amoles
ample94720302ample
anal48037522anal_
ancone83916952ancone
ane37866952an__e
aneled74719282aneled
aneles64626292aneles
angel65019562angel
angled84219092angled
angler74017862angler
angles74426702angles
anglo65215372anglo
anil46437432anil_
anils56326722anils
anime75423202anime
anise55129702anise
anisole71010832anisole
ankled114313482ankled
ankles104818382ankles
anklet105618732anklet
anoa45634472ano_a
anoas57226492anoas
anodes74418762anodes
anolyte10159002anolyte
anomie83215962anomie
anomy105113392anomy
anon46134852ano_n
ansae55720972ansae
antae56828292antae
ante46538902an_te
antler64615552antler
antre55224522antre
anyone94612732anyone
apple94517672apple
areole61017282areole
argle65421562argle
arose55832082arose
atoll57913922atoll
atone56527982atone
awoke124912002awoke
awol75620672awol_
awols84713522awols
axile126020512axile
axle116424602a_xle
axone125918472axone
azoles154614612azoles
azote144416342azote
bangle94018952bangle
bole66448692_bole
cajole154011182cajole
candle94321482candle
canoe75627252cano_e
canola8313622canola
cantle84522152cantle
cole66956112_cole
dandle84218092dandle
dangle84119302dangle
dhole95215362dhole
dole56550002_dole
enol45823822enol_
enols54718402enols
gnome84213952gnome
handle104219292handle
hantle94318202hantle
haole84820082haole
hole77553392_hole
indole74516052indole
ingle64120432ingle
inkle94515832inkle
insole63515862insole
jangle144416292jangle
jole117233822_jole
knoll9389602knoll
lanose6313592lanose
mangle93921322mangle
manhole12311342manhole
mantle84420922mantle
mole66251832_mole
noble74420992_noble
node513036882_node
noel45226552_noel
nolo46229312_nolo
nome66038422_nome
none45743172_none
nope65934192_nope
nose46739362_nose
note46239962_note
obole75917142obole
ole37155212__ole
parole84425252parole
pinole83218782pinole
pole65951302_pole
prole74527792prole
rankle103414882rankle
role45851822_role
snore55424952snore
sole46053672_sole
stole54928812stole
tangle74019952tangle
thole85620842thole
tole46052902_tole
uncle7317052uncle
vole75236982_vole
wandle105316662wandle
wangle103817502wangle
whole114418092whole

Search took 5 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 Filter178691538000.626285448.9
2DLD Change Limit538001353.53015240.8
3Display Results1351350.0334090.9
 (SQL Overall)1786911354.18942657.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.