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

108 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
venal8552321(None) 
penal75228371penal
renal55929501renal
veal76936811ve_al
veinal93812961veinal
vena76126291vena_
venae85920981venae
venial94218281venial
vernal93514211vernal
vinal85725811vinal
anal48037522_anal
annal56520762annal
banal75925992banal
benzal1739642benzal
binal75323822binal
canal75428042canal
cecal94619112cecal
cental84420962cental
deal56347412de_al
decal85523232decal
dedal75719022dedal
denar65223292denar
denial74720512denial
dental74319172dental
egal55119432_egal
enol45823822_enol
feal713940422fe_al
fecal105119212fecal
feral85424652feral
fetal85623372fetal
final83922032final
genial74917612genial
heal75645692he_al
hemal104419802hemal
juvenal1743392juvenal
kenaf12316032kenaf
leal46043272le_al
legal65715942legal
lienal63912782lienal
meal65643172me_al
medal86221332medal
menad85918982menad
menial84223032menial
mensal84615662mensal
mental84521602mental
metal75427382metal
peal68648102pe_al
pedal86022502pedal
penial84120892penial
petal76526892petal
real45750292re_al
regal65023792regal
regnal74812932regnal
renail65020762renail
rental63922022rental
seal45654372se_al
sendal73314992sendal
sepal77723002sepal
seral56336382seral
setal56430902setal
teal45546502te_al
tenail64516112tenail
tepal76319582tepal
thenal92712422thenal
tonal53724302tonal
uveal84411072uve_al
vagal94613632vagal
vandal103713832vandal
vasal85516292vasal
veals84926192ve_als
vealy115817772ve_aly
veena81912322veena_
veenas91410412veenas
vegan95114152vegan
veil75523592ve_il
vela75725542vela_
velar85817632velar
venally13119562venally
vend86626422ven_d
vends95520892vends
venge95117992venge
venin85118662venin
venom103914862venom
vent76049052ven_t
ventail10310452ventail
ventral103612172ventral
vents86125932vents
venue84918212venue
venule94411762venule
venus84918902venus
vera76828842vera_
verbal112513662verbal
versal93013752versal
vestal94615572vestal
vexil1538962vexil
vial76731092v_ial
vina76331802vina_
vinals94716482vinals
vinas85126342vinas
vineal94814742vineal
vinyl115311622vinyl
viral86419592viral
vital84819672vital
vocal104715642vocal
weal75838682we_al
xenial133414902xenial
zeal135530332ze_al
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.313570897.8
2DLD Change Limit538001081.53035163.4
3Display Results1081080.0303600.0
 (SQL Overall)1786911081.87395403.6
 
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.