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

63 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
veronica134673(None) 
veronicas1446391veronicas
erotica92811512_erotica
acronic112814693acronic_
acronical1347833acronical
aeonic83517043ae_onic_
aerobia939463aerobi_a
aerobic11310213aerobic_
aerobics1246833aerobics
armonica1276863armonica
arnica8310443_ar_nica
begonia1047213begoni_a
boronic11311163boronic_
cerotic11415053cerotic_
chronic14311413chronic_
chronics1538683chronics
demoniac1346873demoniac
demonic12311223demonic_
demonical1446983demonical
ebonics1137193_ebonics
erica7316543_er__ica
erotic82620263_erotic_
erotical101911983_erotical
erotics91914153_erotics
exonic153211413_exonic_
exotica16257603_exotica
gerontic1147963gerontic_
harmonica16105753harmonica
hedonic1339043hedonic_
hedonics1445903hedonics
hernia9312293her_ni_a
heroic113516923hero_ic_
heroical13410013hero_ical
heroics122912003hero_ics
ironic8313773_ironic_
ironical1049963_ironical
japonica19114033japonica
ketonic1349923ketonic_
melodica1344983melodica
meropia1149613meropi_a
meropic13310263meropic_
mesonic11310093mesonic_
moronic11311863moronic_
neuronic1049013neuronic_
overnice13310093over_nice
peponida1345183peponida
sermonic1248883sermonic_
tyronic1239313tyronic_
valonia1048303valoni_a
veranda1156323veran_da
verdict1339583ver_dict
veridic1338143veridic_
veridical1545983veridical
verjuice2042573verjuice
vernicle1346433ver_nicle
vernier102711273ver_nier
vernix1636633ver_ni_x
verruca1243713ver_ruca
vertical13410433ver_tical
vesica11157913ve__sica
vibronic1545133vibronic_
vomica1336383v__omica
xerotic16410853xerotic_

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit146162638.73316736.7
3Display Results63630.0331909.1
 (SQL Overall)178691638.93919990.0
 
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.