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

217 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
dialogs93810(None) 
dialog837971dialog_
analogs82810452analogs
decalogs1245632decalogs
dialers83614302dialers
dialings10329822dialings
dialoged1146692dialoged
dialoger1056082dialoger
dialogers1155162dialogers
dialogic1247442dialogic
dialogist1148272dialogist
dialogue1044792dialogue
dialogues1144812dialogues
dials64925342dial__s
diatoms1039072diatoms
diglots9299502diglots
diploes101111492diploes
duologs935362duologs
aloes54933673__aloes
analog7159973analog_
analogy11177853analogy
apologs1038593apologs
bailors93212413bailors
beclogs1237073beclogs
bialies93618413bialies
bialis83617163bial_is
bialys11387913bial_ys
billons93013363billons
billows123611293billows
biogs85016113bi__ogs
biology1337363biology
blogs85319233__blogs
calos74431903_calo_s
catalogs1148033catalogs
clogs85519553__clogs
cologs96517353_cologs
dadoes85616533d_adoes
dados75522433d_ado_s
dagoes85714603d_agoes
dagos76419443d_ago_s
dags66642603d_a__gs
daikons12186693daikons
dailies84219263dailies
daimons10249323daimons
dales66439743d_al_es
dalles74222063d_alles
dals57145123d_al__s
daltons8310403d_altons
dangs75623203d_a_ngs
datos65222783d_ato_s
deacons10310393deacons
dealers84118613dealers
dealings103510703dealings
deals65435343deal__s
decalog1136003decalog_
defogs1156683d_efogs
demagogs1343883demagogs
deploys1336523deploys
dhals95415443dhal__s
diabolo1065483diabolo
diabolos1174643diabolos
diacids1137863diacids
diadems1135393diadems
dial55935063dial___
dialect101210263dialect
dialects11126003dialects
dialed84716453dial_ed
dialer74315433dial_er
dialing94318173dialing
dialist8517763dialist
dialists9411413dialists
diallage1045233diallage
diallages1145463diallages
dialled9510133dialled
diallel845683diallel
dialler848813dialler
diallers957773diallers
diallings1134993diallings
diallist949553diallist
dialoging1246313dialoging
dialogists1265603dialogists
dialogued1243693dialogued
dialoguer1143163dialoguer
dialoguers1242213dialoguers
dialyse1135463dialyse
dialyses1236133dialyses
dialysis1245413dialysis
dialyze2044433dialyze
dialyzes2144503dialyzes
diamins10312213diamins
diamond1186113diamond
diamonds12125173diamonds
diapers104713913diapers
diapirs10347643diapirs
diaries83321953diaries
diatom939453diato_m
diatrons939613diatrons
diazins1739183diazins
diazo15310033diazo__
diazole1736793diazole
diazoles1836323diazoles
dicots94915793di_cots
didoes85716963di_does
didos76820813di_do_s
digamous1296063digamous
diglot83014333diglo_t
digs66036053di___gs
dilates83220663dilates
dilators93213193dilators
dildoes9229243dildoes
dildos8179303di_ldos
dillies84122163dillies
dills65530973di_l_ls
dingoes94114833dingoes
dings76331403di__ngs
dinos65428063di_no_s
diobols1036543diobols
diols65521013di__ols
diploe9810153diplo_e
diploic1247763diploic
diploid11310293diploid
diploids1247843diploids
diploma1295933diploma
diplomas1385993diplomas
diplont10311693diplont
diplonts1146473diplonts
diploses111110323diploses
diplosis11128413diplosis
dipoles101013753dipoles
dipsos95310053dipso_s
dirls64720503dirl__s
disallows1343393disallows
disavows1544043disavows
discos94915213disco_s
dislodge1145173dislodge
dislodges1245163dislodges
dittos74111973ditto_s
diurons838823diurons
divots104712203di_vots
doblons1037043doblons
doglegs1034783doglegs
dogs66440153d___ogs
dollops10287963dollops
dolors75115313d_olors
dragons938383dragons
drags75521113dra__gs
drylots1143743drylots
duals65620083dual__s
duolog835803duolog_
epilogs1076583epilogs
etalons739073etalons
fillos94415083fillo_s
filos86125383fi_lo_s
flogs95919963__flogs
galops94712623_galops
giglots9367863giglots
haloes94623863_haloes
halons95720713_halons
halos85230253_halo_s
hidalgos1342203hidalgos
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
idealogy1342943idealogy
igloos738033_igloos
incogs937903_incogs
isologs837433isologs
jailors14328753jailors
jalops15329593_jalops
jealous1438093jealous
kalongs1255443_kalongs
kiangs11378363kia_ngs
kilos95021473ki_lo_s
liangs74410593lia_ngs
lilos55821873li_lo_s
linalols844903linalols
logs57343113___logs
magalogs1245253magalogs
miaous8511693mia_ous
miaows1145473mia_ows
midlegs1156323midlegs
milos75428013mi_lo_s
pianos84315933piano_s
pillows122610123pillows
pilots84018873pi_lots
pilous84717753pi_lous
prologs103512133prologs
putlogs1065083putlogs
quahogs2043163quahogs
rials55026673rial__s
rialtos736613rialtos
sailors73213723sailors
salols64017873_salols
salons63823693_salons
sawlogs1135393sawlogs
seadogs958643seadogs
shaloms1288983shaloms
sialids839723sialids
sialoid8310963sialoid
sials54227243sial__s
siglos7311473siglo_s
silos56029433si_lo_s
slaloms9106543slaloms
slogs64521843__slogs
stalags838643stalags
tailors73212393tailors
talons64019433_talons
tiglons837343tiglons
unclogs1036803unclogs
valors93413773_valors
vials85822383vial__s
viators102712023viators
villous102810023villous
weblogs1334223weblogs
willows13299753willows
zealots1636763zealots
zealous1637813zealous

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.1561145455.1
2DLD Change Limit1340272176.15621771.8
3Display Results2172170.0762855.3
 (SQL Overall)1786912176.38827972.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.