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

121 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
anoles6482743(None) 
amoles84122191amoles
aneles64626291aneles
angles74426701angles
ankles104818381ankles
anodes74418761anodes
anole55330381anole_
azoles154614611azoles
abeles84719392abeles
ables75935542a_bles
abodes94417512abodes
aboves114512842aboves
acnodes1037832acnodes
addles84216602addles
adobes94411532adobes
adores74420722adores
agones75719862agones
aholds10469482aholds
aiolis6316842aiolis
aisles64721142aisles
ales47067102a__les
aloes54933672alo_es
ambles105121862ambles
amole75724592amole_
ancones93116342ancones
anele55628832anele_
aneled74719282aneled
anes45255932an__es
angels74416172angels
angle64528882angle_
angled84219092angled
angler74017862angler
anglers84014822anglers
anglos74413912anglos
anile54634462anile_
anils56326722anil_s
animes84719592animes
anises64826692anises
anisoles81010122anisoles
ankle95220252ankle_
ankled114313482ankled
anklet105618732anklet
anklets114310412anklets
anlas55626932an_las
anoas57226492ano_as
anode65021042anode_
anolytes11169212anolytes
anomies93316992anomies
antes56334322an_tes
antler64615552antler
antlers74014742antlers
antres65021002antres
anuses66218772anuses
apples104315762apples
areoles71016952areoles
argles75218482argles
arles56735742a_rles
atolls65511352atolls
atones65225772atones
awols84713522awol_s
axles125219472a_xles
axones134614512axones
azole145118032azole_
azotes154312222azotes
bangles103617412bangles
boles75448602_boles
cajoles163712102cajoles
candles104422342candles
canoes84725882cano_es
canolas9313992canolas
cantles94721412cantles
coles76055062_coles
dandles94218532dandles
dangles93618422dangles
dholes104914792dholes
doles67843752_doles
enols54718402enol_s
gnomes93812972gnomes
gnoses76515162gnoses
handles114020652handles
hantles104117512hantles
haoles94919802haoles
holes84748652_holes
indoles83716362indoles
ingles74420872ingles
inkles103515652inkles
insoles73516242insoles
jangles154015682jangles
joles125230832_joles
knolls10367412knolls
mangles104021462mangles
manholes13311182manholes
mantles94820702mantles
moles74747922_moles
nobles83319722_nobles
nodes64633492_nodes
noels56418702_noels
noes45845392_no_es
nolos54423352_nolos
nomes74933122_nomes
nones55639132_nones
noses55435642_noses
notes55034582_notes
oboles83815832oboles
oles46453472__oles
paroles95025882paroles
pinoles93418702pinoles
poles75351002_poles
proles84627202proles
rankles113114542rankles
roles56747982_roles
snores64324322snores
soles55547922_soles
stoles63927672stoles
tangles83920052tangles
tholes94919782tholes
toles55147132_toles
uncles8317162uncles
voles86234042_voles
wangles113416932wangles
wholes124616772wholes

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511212.70330540.5
3Display Results1211210.0304033.3
 (SQL Overall)1786911213.07658092.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.