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 “begonia” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
begonia104721(None) 
begonias1146261begonias
bedsonia1153752bedsonia
begone9512132begon_e
begorra1043542begorra
bignonia1144232bignonia
gonia64117532__gonia
oogonia846482oogonia
pogonia1048932pogonia
aeonian738353ae_onian
aeonic83517043ae_onic
aerobia939463aerobia
agonic93515143_agonic
ammonia1148693ammonia
aphonia122711883aphonia
atonia63816513_atonia
bagnio937523bag_nio
baronial1049483baronial
beanie83618593be_anie
beatnik1344863beatnik
bedouin1046043bedouin
bedsonias1243013bedsonias
began86319573began__
begging123012653begging
begin85117353beg__in
begins94415303begin_s
begorah1355593begorah
begorrah1441823begorrah
begot84625953bego__t
begrim11118333beg_rim
beguine1068503beguine
begun85113443begun__
belon73924113belon__
belong93411043belon_g
belongs10408223belongs
belons84119413belon_s
benni74715363be_nni_
bennis84314803be_nnis
beton76022063beton__
betonies10413063betonies
betons84919553beton_s
betony114211583beton_y
bevomit1445353bevomit
beyond1237073beyon_d
beyonds1335063beyonds
biennia994933biennia
bignonias1243783bignonias
bionic103614573b_ionic
boltonia1045513boltonia
bonita8312943b__onita
boronic11311163boronic
bosonic1139213bosonic
bubonic1366243bubonic
bygone1256173bygon_e
bygones1335913bygones
celosia939463celosia
demoniac1346873demoniac
demonian1147713demonian
demonic12311223demonic
devonian1244813devonian
egomania11136393_egomania
eonian6311833_e_onian
eugenia847713eugenia
exonic153211413_exonic
gonif94320923__gonif
hedonic1339043hedonic
hernia9312293he_rnia
ketonic1349923ketonic
legong836963legon_g
legongs934543legongs
logania847833logania
mahonia1238443mahonia
melodia1038883melodia
meropia1149613meropia
mesonic11310093mesonic
negroni846833negroni_
negronis947263negronis
oogonial945253oogonial
peloria9310953peloria
pennia84412973pe_nnia
peponida1345183peponida
petunia966803petunia
phelonia1347043phelonia
pogonias1148513pogonias
pogonip1245373pogonip
regalia839223regalia
regina75317143regin_a
regna64614813reg_n_a
segni63712483seg_ni_
senopia949233senopia
syconia1248313syconia
tegmina1035243tegmina
tenia55324483te__nia
valonia1048303valonia
veronica1346733veronica
xenia124814773xe__nia

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.1561145455.1
2DLD Change Limit134027967.06318975.9
3Display Results96960.0303200.0
 (SQL Overall)178691967.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.