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

195 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
analog715996(None) 
analogs82810441analogs
analogy11177841analogy
anagoge9166642anagoge
anagogy12174442anagogy
anal48037522anal__
anally9513502anally
analogic1148592analogic
analogue9136242analogue
anglo65215362anglo_
anglos74413902anglos
antilog838622antilog
apolog938902apolog
catalog1038002catalog
dialog837972dialog
magalog1144902magalog
unclog956602unclog
aal39058673a_al__
aalii5316123a_alii
aals49941143a_al_s
abalone938893abalone
abator84512713abator
acajou1595233acajou
agelong934973agelong
aglow94711963a_glow
agog68019003__agog
alamo7418143alamo_
alamos8415003alamos
alang66023513ala_ng
allod64418373a_llod
allot54933873a_llot
allow85420663a_llow
alloy85519973a_lloy
aloe45540193__aloe
along65419493__along
alow75328593__alow
amadou977593amadou
amatol838683amatol
amazon1736823amazon
ana39559823ana___
anabas8314083anabas
anadem939183anadem
anagoges10187243anagoges
anagogic1245733anagogic
analgia898353analgia
anality10313633anality
analogies101910643analogies
analogism1256753analogism
analogist10410233analogist
analogize19156543analogize
analogous1044833analogous
analogues10126183analogues
analyse10208893analyse
analyst10189323analyst
analyte10158813analyte
analyze19167013analyze
ananke1038283ananke
anaphor1245653anaphor
anarch11310393anarch
anas46649863ana__s
anatomy1246233anatomy
anatto6139913anatto
anattos7138453anattos
ancho104515303ancho_
anchor113911973anchor
anchos114214893anchos
ancon75718233an_con
andro6314163andro_
andros7313303andros
anele55628833anel_e
aneled74719273aneled
aneles64626293aneles
aneling82719503aneling
angakok1141753angakok
angle64528873angl_e
angled84219073angled
angler74017863angler
angles74426703angles
angling92816043angling
anil46437433anil__
anile54634463anil_e
anilin6417793anilin
anils56326723anil_s
anion55028813an_ion
ankle95220253ankl_e
ankled114313473ankled
ankles104818383ankles
anklet105618733anklet
ankling122912063ankling
anlace82513923anlace
anlage72514223anlage
anlas55626933an_las
annal56520763annal__
annals66415923annal_s
annoy869713an_noy
anoa45634473an__oa
anole55330373anol_e
anoles64827423anoles
anon46134853an__on
antifog1146313antifog
antilogs949603antilogs
antilogy1248103antilogy
anting75827023anting
antler64615553antler
antlion7310293antlion
anyhow1544103anyhow
anyon85615223an_yon
apagoge11164683apagoge
apologs1038593apologs
apology1337913apology
axal116520493axal__
azalea1537003azalea
azlon144312873a_zlon
backlog1635773backlog
banal75925993banal__
banally1249223banally
bandog1038723ban_dog
beclog1136863beclog
blog75723823__blog
calo64936443_calo_
calos74431903_calos
canal75428043canal__
canaled103615553canaled
canaling112016403canaling
canals84421663canal_s
cantdog1134573cantdog
catalo8314853catalo_
catalogs1148033catalogs
catalos9414163catalos
chalot113020133chalot
clog76123243__clog
colog86619933_colog
danazol1743253danazol
decalog1136003decalog
dialogs938103dialogs
duolog835803duolog
enamor838753enamor
endlong934823endlong
enhalo987563enhalo_
enhalos1087533enhalos
enology11239813enology
epilog976463epilog
etalon648973etalon
flog85523893__flog
galop84716213_galop
halo76437323_halo_
halon86124863_halon
halos85230253_halos
hangdog1343133hangdog
incog838253in_cog
inflow1235293inflow
isolog737403isolog
jalop144212603_jalop
kalong1177703_kalong
linalol745093linalol
log46252683___log
magalogs1245243magalogs
monolog10259353monolog
nabob93913743_nabob
nag46450813_na__g
nala46930393_nal_a
nalas55528363_nalas
naled65525053_naled
naoi46024633_na_oi
naos47429733_na_os
nog46847313_n__og
nolo46229313_nolo_
nolos54423353_nolos
nylon82910513_nylon
prolog94212973prolog
putlog965553putlog
quahog1944103quahog
salol55222143_salol
salon55228553_salon
sandhog1275453sandhog
sandlot8311693sandlot
santalol844793santalol
sawlog1035793sawlog
seadog838743seadog
shalom11810913shalom
slalom888173slalom
slog56728273__slog
snag55827873sna__g
snog55623633sn__og
stalag7310023stalag
synagog1243623synagog
tagalong1042753tagalong
talon55824113_talon
tapalo839793tapalo_
tapalos938813tapalos
unclogs1036803unclogs
unplug954413unplug
valor83614893_valor
weblog1234223weblog
zealot15313473zealot

Search took 6 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.1401276364.3
2DLD Change Limit1127161954.84323274.0
3Display Results1951950.0633095.2
 (SQL Overall)1786911955.04635412.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.