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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
velaria103892(None) 
deliria868302deliria
filaria1039652filaria
malaria9313702malaria
peloria9310952peloria
solaria7312492solaria
talaria7412522talaria
varia85824202v__aria
vedalia1145682vedalia
velamina1345662velamina
velar85817632velar__
velarium1347072velarium
velarize2048762velarize
velars93913722velar_s
veratria1146362veratria
vivaria1346982vivaria
adularia945053adularia
angaria8311583angaria
aplasia92510803aplasia
aquaria1638043aquaria
aria46245423___aria
calcaria1249543calcaria
caldaria1148953caldaria
calvaria1347893calvaria
celeriac1246163celeriac
celosia939463celosia
cercaria1246963cercaria
ceria75125353ce__ria
cesarian1048183cesarian
clarkia1334873_clarkia
dearie73319813de_arie
denari710917353denari_
denarii8389123denarii
elain55324703_ela_in
elapid939543_elapid
eluvia936133_eluvia
feria85922713fe__ria
filariae1148473filariae
filarial1147863filarial
filarian1148313filarian
fusaria1046223fusaria
galabia1038333galabia
gelada837623gela_da
gelati73814533gelati_
gelatin83514733gelatin
gelatis83313513gelatis
gematria1175693gematria
gerardia1044673gerardia
gloria71910553_gloria
hegari1039523hegari_
hegaris11310433hegaris
heparin12410433heparin
herbaria1346093herbaria
hetaira1045903hetaira
kerria10339913ke_rria
labia75219013__labia
lamia75324323__lamia
lari45839153__lari_
lariat6629043__lariat
laris54737463__laris
larva8312483__larva
latria62313603__latria
malarial10410613malarial
malarian10311563malarian
malarias10313773malarias
maria75032883__maria
megara9310093megar_a
melanian1048483melanian
melanic11310403melanic
melanin9310893melanin
melodia1038883melodia
miliaria1048783miliaria
pelagial1146543pelagial
pelagic1237863pelagic
pelorian1048883pelorian
pelorias10410593pelorias
peloric11310713peloric
puparia1147353puparia
realia6314593re_alia
regalia839223regalia
relaid75518443rela_id
relaxin14239183relaxin
rosaria749253rosaria
salariat8416303salariat
sedarim1047113sedarim
senarii7269143senarii
septaria1047413septaria
sharia93116733_sharia
solatia7312253solatia
sudaria847973sudaria
telia55821143tel__ia
terraria847013terraria
tilapia945553tilapia
valerian1147123valerian
valeric1238303valeric
valonia1048303valonia
vara75530883v__ar_a
varias95019903v__arias
varix154313513v__arix
varna84516173v__arna
vedalias1245153vedalias
vela75725543vel___a
velamen1237123velamen
velarized2256803velarized
velarizes2148643velarizes
velate93720143vela_te
velcro1144133velcr_o
velcros1244033velcros
velure939773velur_e
velured1136683velured
velures1039093velures
veluring1237563veluring
venatic12311523venatic
vera76828843ve__r_a
veranda1156323veranda
veratrias1246563veratrias
veratrin1147703veratrin
vicarial1347793vicarial
volar86917413volar__
vulgarian1354263vulgarian
zoaria1548383_zoaria

Search took 7 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 Filter1786911340270.393454684.5
2DLD Change Limit1340271216.07622058.4
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.51527427.6
 
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.