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

139 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
viga8562296(None) 
giga66720941giga
via65636241vi_a
vig75637521vig_
vigas94817881vigas
vigia94813271vigia
vigs85427271vigs
vina76331801vina
virga9310251virga
visa76323871visa
vita75828521vita
viva106119091viva
aga410447232_aga
alga57927602alga
amiga85514812amiga
anga56831362anga
big67345722big_
bigs76235022bigs
bima86723832bima
cig67036182cig_
cigar8911802cigar
cigs75625102cigs
dig57544472dig_
digs66036052digs
dita56032522dita
diva85920882diva
fig76242832fig_
figs85332642figs
fila74729132fila
gaga66625552gaga
gig56040752gig_
gigas75415582gigas
gigs66631182gigs
high116619922high
hila76228352hila
igg57116792_igg
jig115633512jig_
jigs126524762jigs
juga126417322juga
kina85632002kina
kiva116516412kiva
ligan67920282ligan
lima65734132lima
linga66820822linga
lipa68425922lipa
lira46928682lira
mega77620872mega
mica86428252mica
mig65646082mig_
migg85716802migg
migs76935322migs
mina65136922mina
nigh85220662nigh
nipa69421632nipa
pia56848032pi_a
pica85831492pica
pig65744972pig_
pigs76634222pigs
pika106322952pika
pima85428652pima
pina65842632pina
pita65436432pita
raga55930812raga
ria36745502ri_a
rig46748122rig_
rigs55137592rigs
ruga56121232ruga
saga55331172saga
saiga64717932saiga
sigh85625892sigh
sigla64515202sigla
sigma84513832sigma
sign55523052sign
signa66114702signa
sika86021322sika
sima64730782sima
taiga64115672taiga
toga57027412toga
vagal94613632vagal
vagi86719362vagi
vara75530882vara
vasa76522972vasa
veg76931062veg_
vegan95114152vegan
vela75725542vela
vena76126292vena
vera76828842vera
vial76731092vial
vibe95124502vibe
vicar10513862vicar
vice95732852vice
vid77241812vi_d
vide85432762vide
vids85627542vids
vie65447632vi_e
vied86328632vied
vier75428152vier
vies75238622vies
view105917672view
vigias104110892vigias
vigil94313002vigil
vigor92612422vigor
vile76139802vile
vill75235072vill
villa85321232villa
vim87437022vi_m
vims95423312vims
vinal85725812vinal
vinas85126342vinas
vinca105315162vinca
vine75643682vine
vino76128432vino
viny106025952viny
viol76523592viol
viola85915542viola
viral86419592viral
virgas1048882virgas
virl76224472virl
vis66747612vi_s
visas84317652visas
vise75632672vise
vista85416602vista
vitae84217632vitae
vital84819672vital
vitta85015172vitta
vivas114815022vivas
vive105426622vive
voila84813942voila
vug76127412vug_
vugg95612712vugg
vugh117115722vugh
vugs87022872vugs
wig76740382wig_
wigan95114392wigan
wigs84931252wigs
yoga87418052yoga
yuga85615422yuga
zig136931902zig_
zigs145422792zigs

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 Limit298721390.73340753.1
3Display Results1391390.0304633.3
 (SQL Overall)1786911391.029173655.0
 
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.