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

214 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
vinas8512634(None) 
kinas95626911kinas
minas75434111minas
pinas75434451pinas
vigas94817881vigas
vina76331801vina_
vinal85725811vinal
vinals94716481vinals
vincas113912451vincas
vines85137641vines
vinos84723071vinos
visas84317651visas
vivas114815021vivas
ains46158882ain_s
anas46649862_anas
annas55824882annas
avians93711562avians
bias64738152bi_as
bimas95521742bimas
binal75323822binal
binds86627472binds
bines76946792bines
bins66548242bin_s
bints76130182bints
bunas75126572bunas
chinas115119382chinas
cines75239682cines
dinar66319892dinar
dinars75417562dinars
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
ditas65923672ditas
divas95418582divas
donas65926472donas
etnas54713932etnas
final83922032final
finals94316162finals
fincas113512072fincas
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
gigas75415582gigas
ginks104319562ginks
gins55543952gin_s
hinds96721472hinds
hins76447992hin_s
hints87330622hints
inks86926502_inks
inns46920932_inns
ins35945602_in_s
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
kanas95326912kanas
kina85631992kina_
kinase104210652kinase
kinds106221812kinds
kines95039132kines
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
kivas124614732kivas
lianas63713382lianas
limas75627632limas
linac7315412linac
linacs8310812linacs
lines57054572lines
lingas75116562lingas
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
liras56021982liras
litas54923772litas
lunas55025012lunas
manas76240422manas
micas96823052micas
mina65136902mina_
minae75627722minae
minds85427122minds
mines75651952mines
minis75432982minis
minks115829272minks
mints76834042mints
minus75223932minus
monas74732152monas
mynas105815232mynas
nanas55928632nanas
nines55937342nines
ninjas1386302ninjas
nipas77116672nipas
nonas55126652nonas
oinks94819912oinks
ovines94614342ovines
pians75126962pians
pias66542552pi_as
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pina65842632pina_
pines76048862pines
pings85830882pings
pinks115729382pinks
pinnas85315512pinnas
pins65558452pin_s
pintas85021392pintas
pints75936222pints
pitas77427672pitas
punas74826752punas
rias45540592ri_as
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rin_s
sikas94617022sikas
simas75727552simas
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
tineas64616472tineas
tines54848422tines
tings65329192tings
tins45251302tin_s
tints56030922tints
tunas54224122tunas
ulnas55716532ulnas
vaginas11298812vaginas
vandas103915992vandas
vanes85130972vanes
vangs96319582vangs
vans76236722van_s
varas86028192varas
varnas94212822varnas
vas67755772v__as
veenas91410412veenas
veinal93812962veinal
veins84620492vein_s
vena76126292vena_
venae85920982venae
venal85523212venal
vends95520892vends
vents86125932vents
venus84918902venus
via65636242vi_a_
vial76731092vi_al
vials85822382vials
viand9511072viand
viands1047812viands
vibes104719952vibes
vicar10513862vicar
vicars11712262vicars
vices105725532vices
vicunas1285612vicunas
vids85627532vi_ds
viers85621952viers
vies75238622vi_es
views11489642views
viga85622962viga_
vigias104110892vigias
vigs85427272vi_gs
villas96117262villas
vills86429322vills
vims95423312vi_ms
vinasse1044512vinasse
vinca105315162vinca
vine75643682vin_e
vineal94814742vineal
vined95626152vined
vinic10314972vinic
vino76128432vin_o
vinous93914172vinous
viny106025952vin_y
vinyl115311622vinyl
vinyls12467002vinyls
violas93713522violas
viols86118102viols
viral86419592viral
vires84529682vires
virgas1048882virgas
virls85618602virls
virus85316842virus
vis66747612vi__s
visa76323872visa_
vises84427772vises
vistas94513272vistas
vita75828522vita_
vitae84217632vitae
vital84819672vital
vitals94514302vitals
viva106119092viva_
winds95425602winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172win_s
yins75335122yin_s
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735002zin_s

Search took 3 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.1101624463.6
2DLD Change Limit538002141.84329191.5
3Display Results2142140.0603566.7
 (SQL Overall)1786912142.01388768.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.