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

103 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
vinal8572581(None) 
binal75323821binal
final83922031final
veinal93812961veinal
venal85523211venal
vial76731091vi_al
vina76331801vina_
vinals94716481vinals
vinas85126341vinas
vineal94814741vineal
vinyl115311621vinyl
viral86419591viral
vital84819671vital
anal48037522_anal
annal56520762annal
banal75925992banal
canal75428042canal
clinal8311552clinal
dial55935062di_al
dinar66319892dinar
finale94116762finale
finals94316162finals
finial92814182finial
gingal81010152gingal
jingal1498592jingal
kina85631992kina_
kinas95626912kinas
lienal63912782lienal
linac7315412linac
lineal65616022lineal
mina65136922mina_
minae75627722minae
minas75434112minas
nidal65217102nidal
nival84915772nival
penal75228372penal
pial65636702pi_al
pibal95217322pibal
pical95524372pical
pina65842632pina_
pinas75434452pinas
pineal84817682pineal
pinnal84814272pinnal
pipal95118352pipal
renal55929502renal
rhinal9510192rhinal
rial45938092ri_al
rival85216502rival
riyal84413432riyal
sial45938832si_al
signal73711482signal
sisal54217732sisal
spinal84915312spinal
tical76021492tical
tidal64516442tidal
tincal83913362tincal
tineal66216162tineal
tonal53724302tonal
trinal6516962trinal
urinal6614122urinal
vagal94613632vagal
vaginal11288402vaginal
vandal103713832vandal
vasal85516292vasal
veal76936812v_eal
vena76126292vena_
venae85920982venae
venial94218282venial
vernal93514212vernal
via65636242vi_a_
vials85822382vi_als
viand9511072viand
vicar10513862vicar
vicinal12268542vicinal
viga85622962viga_
vigas94817882vigas
vigil94313002vigil
vill75235072vi_ll
villa85321232villa
viminal12288822viminal
vinca105315162vinca
vincas113912452vincas
vine75643682vin_e
vined95626152vined
vines85137642vines
vinic10314972vinic
vino76128432vin_o
vinos84723072vinos
viny106025952vin_y
vinyls12467002vinyls
viol76523592vi_ol
viola85915542viola
virl76224472vi_rl
visa76323872visa_
visas84317652visas
visual938802visual
vita75828522vita_
vitae84217632vitae
vitals94514302vitals
viva106119092viva_
vivas114815022vivas
vocal104715642vocal
zonal145116852zonal

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.0961861364.6
2DLD Change Limit538001031.67032215.6
3Display Results1031030.0166437.5
 (SQL Overall)1786911031.782100275.5
 
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.