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

274 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
slogans840798(None) 
logans76319061_logans
slogan7539221slogan_
bogans95714812_bogans
brogans1049662brogans
hogans105914312_hogans
lagans75717782_lagans
ligans76817732_ligans
loans56026462_lo_ans
logan68123282_logan_
logins77820642_logins
logons79818172_logons
longans84510812_longans
lorans65117602_lorans
shoguns1134422shoguns
shorans102812412shorans
slogs64521842slog__s
slovens10316572slovens
solans64122492s_olans
soldans83210402soldans
somans84619302s_omans
sowans94215892s_owans
ajowans1734003ajowans
alans55636173al__ans
alegars838933alegars
algas65624933al_ga_s
algins74816433al_gins
aligns75312953alig_ns
alloxans1545243alloxans
alohas9411703aloha_s
aloins65022203alo_ins
biogas94310913bioga_s
biogens1038963biogens
bloats85215763blo_ats
blogs85319233blog__s
blowguns1442163blowguns
bogan87519003_bogan_
bolognas1144073bolognas
brogan9311043brogan_
clans75031013cl__ans
cleans85817053cl_eans
cloaks124411263clo_aks
clogs85519553clog__s
clons75228133clo__ns
clowns114810113clo_wns
cogons96818113_cogons
cotans81317923_cotans
dioxans1555313dioxans
dolmans10479683dolmans
elans55527753el__ans
elegant8311503elegant
eloigns8425353eloigns
eloins65419383elo_ins
exogens1536883exogens
flagons1137973flagons
flans85327973fl__ans
floats96816253flo_ats
flogs95919963flog__s
florals104210063florals
floras94715693flora_s
florins10311643florins
flotas94013003flota_s
glans65125833gl__ans
gleans75014743gl_eans
gloams95210663glo_ams
gloats74515423glo_ats
globins10278953globins
gloggs935033glog_gs
glucans1045293glucans
glycans1344233glycans
gobans94412043_gobans
gowans105512293_gowans
groans74815063gro_ans
halogens1237363halogens
hogan97817703_hogan_
honans94814503_honans
isogons8217613isogons
koans95818623_ko_ans
kurgans12145653kurgans
lagan66520343_lagan_
laogais845813laogais
lauans65113533_lauans
leans55536253_l_eans
legals73412733_legals
lemans85316393_lemans
ligan67920283_ligan_
ligand85011293_ligand
ligands9438983_ligands
lignans8398853_lignans
limans84816303_limans
loads65323373_lo_ads
loafs85616993_lo_afs
loams75619863_lo_ams
loan47436453_lo_an_
locals83714503_locals
lochans1248833_lochans
lodens74315063_lodens
logania847833_logania
loges66534203_log_es
loggats9286453_loggats
logics95711123_logics
login66025003_login_
logions86211293_logions
logjams1743583_logjams
logon615922313_logon_
logos67225333_log_os
logs57343113_log__s
logways1434513_logways
loins56728423_lo_ins
longan75612363_longan_
loons55731723_lo_ons
loran55925093_loran_
lotahs9479873_lotahs
lotas55926303_lota_s
lovats939073_lovats
lungans8399053lungans
moans74624373_mo_ans
morgans10310123morgans
ogams84112683__ogams
ologies8615023ologies
organs7912913_organs
origans839973origans
pagans95717923_pagans
plans75731273pl__ans
platans93413123platans
prolans9314273prolans
reloans7313133relo_ans
roans54926443_ro_ans
romans84620243_romans
rowans95715343_rowans
ryokans1443293ryokans
sagas66025883s_aga_s
saggars93610683saggars
saigas74114293saiga_s
salons63823693salo__ns
saloons74415313salo_ons
salpians1036763salpians
saltpans1034813saltpans
sampans112411003sampans
sangars83116253sangars
sangas75222653sanga_s
sans45153363s___ans
sarans64224433s_arans
scans74625103s__cans
scorns85713023sco_rns
seawans10379943seawans
sedans74816093s_edans
seggars9377783seggars
seitans73312303seitans
sewans95215903s_ewans
sextans14349263sextans
shamans123610903shamans
shoals94215793sho_als
shoats94117083sho_ats
shofars1335833shofars
shogis103810943shog_is
shogs95319713shog__s
shogun1045713shogun_
shoran94016043shoran_
shotguns1242313shotguns
signs65516323s_ig_ns
siloxane1543743siloxane
siloxanes1643613siloxanes
silvans10308333silvans
simians959203simians
skeans104512913s_keans
skoals10438243sko_als
slabs75322643sl__abs
slags66525903sl__ags
slams74927903sl__ams
slang66324023sl__ang
slangs75615343sl__angs
slank95822773sl__ank
slant55238703sl__ant
slants64819083sl__ants
slaps76025713sl__aps
slats55436903sl__ats
slaws85222713sl__aws
slays85723683sl__ays
slights112810723slights
slobs74419873slo__bs
sloes54728873slo__es
slog56728273slog___
sloganeer1042373sloganeer
sloganeers1141783sloganeers
sloganize1944593sloganize
sloganizes2044793sloganizes
slogged104910473slogged
slogger94310483slogger
sloggers10418783sloggers
slogging113410493slogging
sloids73712693slo_ids
slojds14345473slo_jds
sloops85513623slo_ops
slopers94213093slopers
slopes84820453slo_pes
sloping104114073sloping
slops75026013slo__ps
sloshes103811803sloshes
sloths94911893slo_ths
slots54830533slo__ts
sloughs11497563sloughs
sloven9389633sloven_
slowing112814743slowing
slows85323463slo__ws
sloyds10346293slo_yds
slugs64618563slug__s
smogs85112163smog__s
snogs66017493snog__s
soaks95220293s_o_aks
soaps75120713s_o_aps
soars54732513s_o_ars
sobas74424253s_oba_s
socas74026183s_oca_s
sodas64123543s_oda_s
sofars94712783s_ofars
sofas85320713s_ofa_s
sojas124716393s_oja_s
solan55328153s_olan_
soland75115043s_oland
solands84412343s_olands
solano65314183s_olano
solanos74412853s_olanos
soldan73511853soldan_
solions7513753solions
solons65120023s_olons
soman75024903s_oman_
somas76030373s_oma_s
sonant6621953s_onant
sonants7511233s_onants
sonars64818973s_onars
sons46049553s_o__ns
soras55041013s_ora_s
sorns55028423s_o_rns
soudans8309353soudans
sovrans1036483sovrans
sowars94318013s_owars
sowens93613153s_owens
soyas84520913s_oya_s
sozins15510793s_ozins
spans74528733s__pans
speans85417143s_peans
spongins1136563spongins
spoons84116013spo_ons
sporrans1045523sporrans
stoas55126023sto_a_s
stoats65117483sto_ats
stogeys11486123stogeys
stogies8413693stogies
stolons73410243stolons
stomas84816323stoma_s
stopgaps1342963stopgaps
stotins73213873stotins
sugars7312423s_ugars
suldans8299723suldans
sultans72411833sultans
suntans72111733suntans
swans84625013s__wans
swoons94511143swo_ons
swouns9358243swo_uns
sylvans13235893sylvans
syngas10368913synga_s
teopans939203teopans
togas67823003_toga_s
tolans64319273_tolans
tomans85419133_tomans
trogons83410723trogons
ulans54921303ul__ans
vegans103910853_vegans
wangans1149503wangans
wigans104511703_wigans
womans114613653_womans
yogas96615603_yoga_s
yogins105114103_yogins

Search took 7 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.1701051123.5
2DLD Change Limit1340272745.97022450.1
3Display Results2742740.0932946.2
 (SQL Overall)1786912746.23328668.5
 
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.