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

157 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
visa7632388(None) 
vasa76522971vasa
via65636251vi_a
viga85622971viga
vina76331811vina
vis66747621vis_
visas84317651visas
vise75632681vise
vista85416601vista
vita75828531vita
viva106119101viva
ais39083582ais_
ansa45927772ansa
aviso85713962aviso
bias64738172bias
bima86723842bima
bis56860672bis_
bise66437112bise
bisk106523362bisk
casa65630862casa
cis57748042cis_
cist67244972cist
dis46459902dis_
disc76123242disc
dish86328342dish
disk96625842disk
diss56434492diss
dita56032532dita
diva85920892diva
fila74729142fila
fisc96819762fisc
fish106926282fish
fist76248432fist
giga66720952giga
gist56046772gist
hila76228362hila
his66359512his_
hisn79620942hisn
hiss75629222hiss
hist76551552hist
is27048222_is_
isba61310882_isba
ism56322392_ism
jism135514782jism
kina85632012kina
kis78051492kis_
kiss85227412kiss
kist86540812kist
kiva116516422kiva
lima65734142lima
lipa68425932lipa
lira46928692lira
lis37162282lis_
lisp68926892lisp
list47055352list
masa65034722masa
mesa67025482mesa
mica86428262mica
mina65136932mina
mis58162632mis_
mise66043592mise
miso67229912miso
miss65339432miss
mist66154542mist
nipa69421642nipa
nisi45823252nisi
ossa43714162ossa
ovisac1153952ovisac
paisa76021072paisa
pia56848042pi_a
pias66542562pias
pica85831502pica
pika106322962pika
pima85428662pima
pina65842642pina
pis56362042pis_
pish96127922pish
piso66727572piso
piss65033342piss
pita65436442pita
qis126934392qis_
ria36745512ri_a
rias45540602rias
rise45945242rise
risk85724112risk
sika86021332sika
sima64730792sima
sis37360552sis_
sisal54217732sisal
tis37056652tis_
ursa44116912ursa
vara75530882vara
vas67755772vas_
vasal85516292vasal
vase75629652vase
vast75045122vast
vela75725542vela
vena76126292vena
vera76828842vera
vest75743602vest
vesta86618302vesta
vial76731102vial
vibe95124512vibe
vicar10513862vicar
vice95732862vice
vid77241822vi_d
vide85432772vide
vids85627552vids
vie65447642vi_e
vied86328642vied
vier75428162vier
vies75238632vies
view105917682view
vig75637532vi_g
vigas94817882vigas
vigia94813272vigia
vigs85427282vigs
vile76139812vile
vill75235082vill
villa85321232villa
vim87437032vi_m
vims95423322vims
vinal85725812vinal
vinas85126342vinas
vinca105315162vinca
vine75643692vine
vino76128442vino
viny106025962viny
viol76523602viol
viola85915542viola
viral86419592viral
virga9310252virga
virl76224482virl
visaed104110502visaed
visage1049082visage
visard103910122visard
vised95518762vised
vises84427772vises
visit8320962visit
visor82512832visor
vistas94513272vistas
visual938802visual
vitae84217632vitae
vital84819672vital
vitta85015172vitta
vivas114815022vivas
vive105426632vive
vizsla1833702vizsla
voila84813942voila
wis66552342wis_
wise75737352wise
wish107228742wish
wisha114910852wisha
wisp97124082wisp
wiss75630552wiss
wist78049302wist
xis106935342xis_

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 Limit298721570.89033564.0
3Display Results1571570.0334757.6
 (SQL Overall)1786911571.189150286.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.