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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
vivas11481502(None) 
divas95418581divas
kivas124614731kivas
vigas94817881vigas
vinas85126341vinas
visas84317651visas
viva106119091viva_
ajivas1655132ajivas
bias64738152bi_as
bimas95521742bimas
devas96218882devas
ditas65923672ditas
diva85920882diva_
divan96114842divan
divans104612392divans
dives95832402dives
favas115618592favas
fives116027362fives
gigas75415582gigas
gives95324872gives
hives116925512hives
javas155915422javas
jives154820812jives
kavas125919952kavas
kinas95626912kinas
kiva116516402kiva_
kvas117015942_kvas
lavas85422222lavas
limas75627632limas
liras56021982liras
litas54923772litas
lives86133192lives
micas96823052micas
minas75434112minas
nipas77116672nipas
nival84915772nival
novas85215362novas
pias66542552pi_as
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pitas77427672pitas
rias45540592ri_as
rival85216502rival
rivals94213182rivals
rives85336002rives
shivas124512412shivas
sikas94617022sikas
silvas92912182silvas
simas75727552simas
ulvas84511502ulvas
varas86028192varas
vas67755772__vas
vavs105720432vav_s
via65636242vi_a_
vial76731092vi_al
vials85822382vials
vibes104719952vibes
vicar10513862vicar
vicars11712262vicars
vices105725532vices
vids85627532vi_ds
viers85621952viers
vies75238622vi_es
views11489642views
viga85622962viga_
vigias104110892vigias
vigs85427272vi_gs
villas96117262villas
vills86429322vills
vims95423312vi_ms
vina76331802vina_
vinal85725812vinal
vinals94716482vinals
vincas113912452vincas
vines85137642vines
vinos84723072vinos
violas93713522violas
viols86118102viols
viral86419592viral
vires84529682vires
virgas1048882virgas
virls85618602virls
virus85316842virus
vis66747612vi__s
visa76323872visa_
vises84427772vises
vistas94513272vistas
vita75828522vita_
vitae84217632vitae
vital84819672vital
vitals94514302vitals
vivace1436552vivace
vivaces1536412vivaces
vivary1536982vivary
vive105426622viv_e
vivers124717362vivers
vivid125112312vivid
volvas12447992volvas
vulvas12388842vulvas
wives115328922wives

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001021.56334421.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911021.686105985.2
 
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.