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

104 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
vizsla183370(None) 
vizslas1943141vizslas
villa85321232vi_lla
viola85915542vi_ola
visa76323872vi_s_a
vista85416602vi_sta
aisle55223193ai_sle
cicala10310053cicala
citola838393citola
eidola737683eidola
fibula11258053fibula
fiesta938123fiesta
fila74729133fi__la
fizzle17369713fizzle
hila76228353hi__la
hirsle9159573hirsle
isba61310873_i_sba
isle45121703_i_sle
kibla1139833ki_bla
ligula7359673ligula
lisle53916723li_sle
miasma1097563miasma
mislay113510683mi_slay
missal84314903missal
mizuna1734303mizuna
mizzle16279993mizzle
mizzly19256103mizzly
pizza1538183piz_za
pizzle16279493pizzle
siesta639503siesta
sigla64515203si_gla
sisal54217733si_sal
sizzle14309613sizzle
tesla55612603_tesla
vasa76522973v_as_a
vasal85516293v_asal
vassal979243vassal
vela75725543v__ela
versal93013753versal
vesta86618303v_esta
via65636243vi___a
viable111613773viable
viably14199833viably
vial76731093vi_al_
vials85822383vi_als
vicuna11115903vicuna
vids85627533vids__
vies75238623vies__
viga85622963vi__ga
vigia94813273vi_gia
vigil94313003vigil_
vigils104210193vigils
vigs85427273vigs__
vile76139803vi__le
vilely1239443vilely
vill75235073vi__ll
villae95615383vi_llae
villas96117263vi_llas
villi86517853vi_lli
vills86429323vi_lls
vimina11339933vimina
vims95423313vims__
vina76331803vi__na
vinal85725813vinal_
vinals94716483vinals
vinca105315163vi_nca
vincula1246393vincula
vineal94814743vineal
vinyl115311623vinyl_
vinyls12467003vinyls
viol76523593vi_ol_
violas93713523vi_olas
viols86118103vi_ols
viral86419593viral_
virelai1045593virelai
virelay1335933virelay
virga9310253vi_rga
virile9313433virile
virl76224473vi_rl_
virls85618603vi_rls
vis66747613vi_s__
visas84317653vi_sas
vise75632673vi_s_e
vised95518763vi_sed
vises84427773vi_ses
visit8320963vi_sit
visor82512833vi_sor
vistas94513273vi_stas
visual938803vi_sual
vita75828523vi__ta
vital84819673vital_
vitals94514303vitals
vitta85015173vi_tta
vittle94711753vittle
viva106119093vi__va
vizard19458853vizard
vizier184311023vizier
vizir17359393viz_ir
vizirs18306713vizirs
vizor173010093viz_or
vizors18328903vizors
voila84813943v_oila
wisha114910853wi_sha
zizzle13247313zizzle

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127161046.09318499.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.31228309.7
 
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.