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

211 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
vera7682884(None) 
era35741501_era
sera46141391sera
vara75530881vara
vela75725541vela
vena76126291vena
verb96224871verb
vert77249371vert
very108025641very
aero45435342aero
aery77231682aery
area45843392area
aura45836252aura
aver75931882aver_
avers85127312avers
avert86029492avert
bear66844642bear
bema85825252bema
berg75425542berg
berk105929842berk
berm86732752berm
beta66234132beta
bora66141632bora
bra56339462_bra
bura66139532bura
ceca84820782ceca
cere66741472cere
ceria75125352ceria
cero66329452cero
dear55343602dear
derat65044082derat
deray95024182deray
dere56845902dere
derm76031892derm
derma84918512derma
deva85720982deva
dura55232112dura
ear36867882_ear
eery76129622eery
er28345142_er_
eras45441502_eras
ere36352772_ere
erg45531072_erg
ern35738362_ern
err35626532_err
ers36046282_ers
eta35834192_eta
ever77027692ever_
evert84929512evert
every115215452every
eyra76217552eyra
fear75337792fear
fer66646122fer_
feral85424652feral
fere76342232fere
feria85922712feria
fern76129322fern
feta76528902feta
fora75937392fora
gear55934972gear
gerah9315302gerah
germ75428962germ
geta56627442geta
hear76143882hear
her66547812her_
herb94730962herb
herd84933062herd
here76447102here
herl75834552herl
herm95636152herm
herma105318882herma
hern76134892hern
hero74635782hero
hers75844872hers
hora76136562hora
jerk154920132jerk
jura116024892jura
kea76540912ke_a
kerb104322712kerb
kerf115827462kerf
kern85326212kern
kora86431552kora
lea37660182le_a
lear47045952lear
leva77020712leva
lira46928682lira
mara67444572mara
mega77620872mega
merc87225622merc
mere67244442mere
merk106027942merk
merl65830972merl
mesa67025482mesa
meta65932412meta
mora66641272mora
mura65633302mura
near45236502near
nema65522522nema
nerd56624942nerd
okra86413572okra
opera7313572opera
ora37250832_ora
orra46120722orra
over77227342over_
overs85224792overs
overt85630722overt
para65242172para
pea56657242pe_a
pear69745232pear
per56353092per_
pere66450262pere
perea75026442perea
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
pert66759322pert
perv97224812perv
rear45644552rear
reran57329102reran
sea36161292se_a
sear47353842sear
ser36752402ser_
serac75925202serac
serai56830162serai
seral56336382seral
sere46153472sere
serf76340112serf
sers45746652sers
seta45637312seta
sora45746912sora
sura45740292sura
tea37353322te_a
tear45242882tear
tela45532972tela
tepa66021682tepa
terai53525482terai
terga63315642terga
term66233152term
tern46134802tern
terra54419662terra
tetra53417952tetra
tora47545992tora
urea46528062urea
uvea74712652uve_a
var66148332var_
varas86028192varas
varia85824202varia
varna84516172varna
vars75742072vars
vary105226062vary
vasa76522972vasa
veal76936812veal
vee65750182ve_e
veena81912322veena
veep95325092veep
veer76229572veer
veers84521362veers
veery115816252veery
vees75439432vees
veg76931062ve_g
vegan95114152vegan
veil75523592veil
vein75625752vein
velar85817632velar
veld85323202veld
venae85920982venae
venal85523212venal
vend86626422vend
vent76049052vent
verbal112513662verbal
verbs104614392verbs
verge93419842verge
vernal93514212vernal
versal93013752versal
verse84723582verse
verso85314632verso
verst84429372verst
verts85724732verts
vertu85017612vertu
verve115417722verve
vest75743602vest
vesta86618302vesta
vet65958522ve_t
veto76622992veto
vets76835092vets
vex136429172ve_x
vext146927762vext
via65636242v_ia
vier75428152vier_
viers85621952viers
viga85622962viga
vina76331802vina
viral86419592viral
virga9310252virga
virl76224472virl
visa76323872visa
vita75828522vita
viva106119092viva
wear75836722wear
weka117013872weka
were76238332were
wert79749822wert
yea66445752ye_a
year76534252year
yerba101010762yerba
yerk116222082yerk
zebra1637882zebra
zerk175319252zerk
zero134822472zero
zeta135121642zeta

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 Filter178691298720.266671770.7
2DLD Change Limit298722110.90632971.3
3Display Results2112110.0464587.0
 (SQL Overall)1786912111.218146708.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.