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

69 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
vividest154520(None) 
divides123211452divides_
divinest123012172divinest
jiviest1738112jivi_est
timidest1136932timidest
viniest103216612vini_est
vivider14265622vivide_r
vividness1643932vividness
vivisect1643782vivisect
acridest1138143acridest
airiest74221013airi_est
aridest8316143_aridest
civies114116443civi_es_
diciest103316523dici_est
divest106820073div__est
divide113410893divide__
divided13378593divide_d
dividend14284713dividend
divider12278953divide_r
dividers13257213dividers
divines113514723divines_
evident1139993_evident
evilest10310473_evilest
giddiest11298553giddiest
iciest82914743_ici_est
imides94515343_imides_
irides74519123_irides_
ivies84215763_ivi_es_
kindest12311503ki_ndest
limiest93716103limi_est
liniest73321153lini_est
lipides103810623lipides_
livest95315733liv__est
lividness1344713lividness
mildest102812063mi_ldest
miriest93619823miri_est
mitiest93520053miti_est
oiliest72817683oili_est
ovicides1445463ovicides_
piniest93121133pini_est
pipiest113114493pipi_est
priviest132310313privi_est
rapidest1138543rapidest
rimiest93215853rimi_est
siziest16311473sizi_est
snidest8310913_snidest
solidest9310383solidest
staidest939803staidest
tidiest83514873tidi_est
tiniest73020123tini_est
tiredest938403tiredest
vainest10315763v_ainest
veiniest1139383veini_est
veriest103719133veri_est
vibist11610583vibi__st
viewiest1435853viewiest
vilest9416843__vilest
vivaces1536413vivaces_
vivid125112313vivid___
vividly1744233vivid_ly
vivifies1747023vivifies_
vivisects1742083vivisects
waviest134513073wavi_est
widest104517003__widest
wildest113311273wi_ldest
wiliest103416593wili_est
windiest122213233windiest
winiest103419693wini_est
wiriest103816853wiri_est

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162697.70018982.1
3Display Results69690.0332090.9
 (SQL Overall)178691697.90622601.9
 
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.