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

180 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
analogs8281045(None) 
analog7159971analog_
analogy11177851analogy
anagoge9166642anagoge
anagoges10187242anagoges
anagogy12174442anagogy
analogic1148602analogic
analogies101910642analogies
analogism1256752analogism
analogist10410232analogist
analogous1044832analogous
analogue9136252analogue
analogues10126182analogues
anglos74413912anglo_s
antilogs949602antilogs
apologs1038592apologs
catalogs1148032catalogs
dialogs938102dialogs
magalogs1245252magalogs
unclogs1036802unclogs
aaliis6312903a_aliis
aals49941143a_al__s
abalone938903abalone
abalones1038753abalones
abators94413083abators
acajous1666483acajous
acaulous1045923acaulous
agamous1037943agamous
alamos8415003alamo_s
allods73615083a_llods
allots64019173a_llots
allows94517683a_llows
alloys94014563a_lloys
aloes54933673__aloes
amadous1038503amadous
amatols938183amatols
amazons1836653amazons
anabas8314083ana_bas
anableps1243123anableps
anadems1036143anadems
anagogic1245733anagogic
anagogies11156163anagogies
anal48037523anal___
analects1047703analects
analgia898363analgia
analgias9107803analgias
anality10313633anality
anally9513503anal_ly
analogisms1345213analogisms
analogists1147313analogists
analogize19156543analogize
analogizes20136033analogizes
analyse10208893analyse
analyses11149963analyses
analysis11128293analysis
analyst10189323analyst
analysts11167443analysts
analyte10158813analyte
analytes11169203analytes
analyze19167013analyze
analyzes20157193analyzes
anankes1138763anankes
anaphors1346633anaphors
anarchs1237093anarchs
anas46649863ana___s
anatomy1246233anatomy
anattos7138453anattos
anchors123912953anchors
anchos114214893ancho_s
andros7313303andro_s
aneles64626293anel_es
angakoks1241883angakoks
anglers84014823anglers
angles74426703angl_es
anglings10228273anglings
anglo65215373anglo__
angulous946223angulous
anilins7416793anilins
anils56326723anil__s
anions64123033an_ions
ankles104818383ankl_es
anklets114310413anklets
anlaces92313733anlaces
anlage72514233an_lage
anlages82414113anlages
anlas55626933an_l_as
anlases72514903anlases
annals66415923annal__s
annoys967523an_noys
anoas57226493an__oas
anoles64827433anol_es
anomalous1145193anomalous
antilog838623antilog_
antilogy1248103antilogy
antings85015583antings
antlers74014743antlers
antlions839193antlions
anurous7311553anurous
anxious1437283anxious
anyons94513503an_yons
apagoge11164683apagoge
apagoges12144693apagoges
apolog938903apolog_
apology1337913apology
azaleas1636993azaleas
azlons154110423a_zlons
backlogs1746633backlogs
bandogs1138363ban_dogs
beclogs1237073beclogs
blogs85319233__blogs
calos74431903_calo_s
canals84421663canal__s
cantdogs1244043cantdogs
cataloes10311653cataloes
catalog1038003catalog_
catalos9414163catalo_s
clogs85519553__clogs
cologs96517353_cologs
danazols1843083danazols
decalogs1245633decalogs
dialog837973dialog_
duologs935363duologs
enamors939123enamors
enhaloes1197343enhaloes
enhalos1087533enhalo_s
enology11239813enology
epilogs1076583epilogs
etalons739073etalons
flogs95919963__flogs
galops94712623_galops
haloes94623863_haloes
halons95720713_halons
halos85230253_halo_s
hangdogs1443603hangdogs
incogs937903in_cogs
inflows1335523inflows
isologs837433isologs
jalops15329593_jalops
jealous1438093jealous
kalongs1255443_kalongs
linalols844903linalols
logs57343113___logs
magalog1144913magalog_
monologs112210533monologs
nabobs10388213_nabobs
nags55436023_na__gs
nalas55528363_nal_as
naleds7469133_naleds
naos47429733_na_o_s
nogs56534613_n__ogs
nolos54423353_nolo_s
nylons9267973_nylons
prologs103512133prologs
putlogs1065083putlogs
quahogs2043163quahogs
salols64017873_salols
salons63823693_salons
sandhogs1365483sandhogs
sandlots938293sandlots
santalols944773santalols
sawlogs1135393sawlogs
seadogs958643seadogs
shaloms1288983shaloms
slaloms9106543slaloms
slogs64521843__slogs
snags64421313sna__gs
snogs66017493sn__ogs
stalags838643stalags
synagogs1343273synagogs
tagalongs1142233tagalongs
talons64019443_talons
tantalous946193tantalous
tapalos938813tapalo_s
unclog956603unclog_
unplugs1042983unplugs
valors93413773_valors
vanadous1246033vanadous
weblogs1334223weblogs
zealots1636763zealots
zealous1637813zealous

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.533335255.2
2DLD Change Limit1340271806.81019680.9
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.40624127.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.