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 “varia” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
varia8582420(None) 
aria46245421_aria
maria75032881maria
vara75530881var_a
varias95019901varias
varix154313511varix
varna84516171varna
agria65517142agria
amia66836902_amia
area45843392_area
arias55438022_arias
arid57642712_arid
aril45843022_aril
atria56022342atria
barca91319432barca
baric96125692baric
cardia9916372cardia
carina84325322carina
ceria75125352ceria
coria75828322coria
curia74523772curia
daric85623112daric
facia103218462facia
farina94618232farina
feria85922712feria
garda7316762garda
jarina134014062jarina
karma113415002karma
labia75219012labia
lamia75324322lamia
lari45839152lari_
lariat6629042lariat
laris54737462laris
larva8312482larva
latria62313592latria
mafia104418032mafia
mania75634152mania
mara67444572mar_a
marina84623412marina
marka114620792marka
naira5314742naira
narial6317952narial
naric76824172naric
naris55735292naris
noria55722182noria
ovarial1037612ovarial
ovarian1037642ovarian
para65242172par_a
pariah114320582pariah
parian83223962parian
paris75145942paris
parka115120882parka
raia46638382ra_ia
ria36745502__ria
sari45444042sari_
sarin55239252sarin
saris54544952saris
sharia93116732sharia
stria55723212stria
tafia84215492tafia
tarsia65514272tarsia
vacua10510462vacua
vagi86719362vagi_
vagina102710932vagina
vail75432552va_il
vain75233002va_in
vair75624142va_ir
vairs85019132vairs
vakil1259792vakil
valid94618392valid
vanda94515922vanda
vapid115614282vapid
var66148332var__
varas86028192varas
variant10316802variant
variate101316432variate
varied104817862varied
varier94619352varier
varies94330872varies
variola1068892variola
varnas94212822varnas
vars75742072var_s
varus85921182varus
varve115716852varve
vary105226062var_y
vasa76522972va_sa
vatic10316422vatic
velaria1038922velaria
vera76828842ver_a
via65636242v__ia
vigia94813272vigia
virga9310252virga
virid94116042virid
vivaria1346982vivaria
zamia165115212zamia
zariba1736982zariba
zoaria1548382zoaria

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.300595636.7
2DLD Change Limit53800971.51335558.5
3Display Results97970.0332939.4
 (SQL Overall)178691971.84696799.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.