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

145 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
duologs93536(None) 
duolog835801duolog_
apologs1038592apologs
cologs96517352_cologs
dialogs938102dialogs
dolors75115312d_olors
duologue1043002duologue
duologues1143392duologues
duomos936822duomo_s
isologs837432isologs
prologs103512132prologs
putlogs1065082putlogs
quohogs2042022quohogs
analogs82810453analogs
apolog938903apolog_
apology1337913apology
beclogs1237073beclogs
biology1337363biology
blogs85319233__blogs
bolos75531373_bolo_s
bugloss1035893bugloss
bulldogs1274243bulldogs
bullous9311663bullous
cholos114716853cholo_s
clogs85519553__clogs
cohogs125810273_cohogs
colog86619933_colog_
colons86028683_colons
colors86622373_colors
decalogs1245633decalogs
decolors1187713decolors
defogs1156683d_efogs
deploys1336523deploys
dholes104914793dhol_es
dialog837973dialog_
diglots9299503diglots
diobols1036543diobols
diols65521013diol__s
diploes101111493diploes
doblons1037043doblons
dodoes85716103d_odoes
dodos75819393d_odo_s
doglegs1034783doglegs
dogs66440153d___ogs
doings84913183d_oings
dojos135111793d_ojo_s
doles67843753d_ol_es
dollops10287963dollops
dolls66126923d_ol_ls
dolmas95213043d_olmas
dolor67617963d_olo_r
dolour75710133d_olour
dolours8438823d_olours
dols56943053d_ol__s
dolts65626313d_ol_ts
dongs76525813d_o_ngs
donors75115793d_onors
doodoos9107623doodoos
doolees83711613doolees
doolies83920713doolies
dooms85321343d_o_oms
doors65022133d_o_ors
doowops1363943doowops
doulas75114993doul_as
doxology2044743doxology
drolls75312393drol_ls
dromons1038193dromons
drongos935493drongos
drools74412813dro_ols
droops95110963dro_ops
drylots1143743drylots
duals65620083dual__s
dubious1036893dubious
duelers83412053duelers
duellos845763duellos
duels65619233duel__s
dugongs1053253dugongs
dugs614832283du___gs
dulias71212743du_lias
dulls64523743du_l_ls
dulses73913653du_lses
dumbos114111083dumbo_s
dungs75821973du__ngs
dunlins849553dunlins
duomo839753duomo__
duopoly1343683duopoly
duos56728133du__o_s
duotone836893duotone
duotones937643duotones
durions839963durions
durocs9569703du_rocs
duros65422693du_ro_s
duteous838453duteous
ecology13218823ecology
enology11239813enology
epilogs1076583epilogs
eulogy1035633eu_logy
flogs95919963__flogs
furlongs12304073furlongs
geology12257323geology
gulags837543gu_lags
gundogs1034603gundogs
homologs1448233homologs
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
ideology1345653ideology
isolog737403isolog_
kolos94921213_kolo_s
logs57343113___logs
monologs112210533monologs
myology1636163myology
neology11238293neology
nolos54423353_nolo_s
ology94113113__ology
oology103210253_oology
oolongs845953_oolongs
orology11319463orology
otology11308753otology
ovolos9257203ovolo_s
photogs13358213photogs
polos76129913_polo_s
prolegs10379993prolegs
prolog94212973prolog_
prolongs11347613prolongs
putlog965553putlog_
quahogs2043163quahogs
quohog1942503quohog_
quolls15327303quol_ls
sawlogs1135393sawlogs
sholoms1278033sholoms
slogs64521843__slogs
solons65120023_solons
solos54830793_solo_s
stolons73410243stolons
sublots92410913sublots
sundogs947103sundogs
theologs1246153theologs
tholos94213003tholo_s
ufology14244563ufology
unclogs1036803unclogs
urology11217583urology
weblogs1334223weblogs
zoology2036513zoology

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.1531167915.0
2DLD Change Limit1340271457.05019010.9
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.24924650.4
 
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.