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

201 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
vial7673109(None) 
dial55935061dial
pial65636701pial
rial45938091rial
sial45938831sial
vail75432551vail
veal76936811veal
via65636241via_
vials85822381vials
vill75235071vill
vinal85725811vinal
viol76523591viol
viral86419591viral
virl76224471virl
vital84819671vital
aal39058672_aal
ail37171042ai_l
al210674042__al
anal48037522anal
avail8313882avail
avian84616052avian
axal116520492axal
axial124515192axial
baal67033112baal
bail65042802bail
bal56662722_bal
biali73419072biali
bialy105119322bialy
bias64738162bias
bill67239942bill
binal75323822binal
birl65830472birl
ciao64924182ciao
coal66939252coal
dal47554952_dal
deal56347412deal
dhal86719282dhal
dials64925342dials
diel59034602diel
dill55239972dill
diol57329132diol
dirl57430022dirl
dual55928172dual
egal55119432egal
evil75318072evi_l
fail74840242fail
feal713940422feal
fiar76427332fiar
fiat76646642fiat
fil65447142fi_l
fila74729132fila
fill75540192fill
final83922032final
foal76630922foal
gal46055512_gal
gavial10310082gavial
gill56336182gill
girl56226552girl
glial66715432glial
goal55829302goal
hail74839062hail
heal75645692heal
hila76228352hila
hill76439492hill
ilial55317842ilial
ill37437092_ill
jail115529092jail
jiao115017842jiao
jill116430262jill
jovial1636542jovial
kail85131492kail
kill85533172kill
leal46043272leal
liar47229682liar
mail65543452mail
meal65643172meal
miaul71612122miaul
mil55752112mi_l
mill66541482mill
nail45838652nail
nidal65217102nidal
nil36144192ni_l
nill45634302nill
nival84915772nival
oil37452052oi_l
opal66923522opal
oral47638122oral
oval77119522oval
pail66141832pail
pal56761672_pal
peal68648102peal
phial10313202phial
pia56848032pia_
pian66136092pian
pias66542552pias
pibal95217322pibal
pical95524372pical
pill65339462pill
pipal95118352pipal
rail46147762rail
real45750292real
ria36745502ria_
rials55026672rials
rias45540592rias
riel46432382riel
rill45140902rill
rival85216502rival
riyal84413432riyal
sail45447162sail
sal36462882_sal
seal45654372seal
sials54227242sials
sill45545152sill
sisal54217732sisal
tail45443652tail
teal45546502teal
tical76021492tical
tidal64516442tidal
til36350262ti_l
till45941202till
tirl45029922tirl
trial54926352trial
urial54823022urial
uveal84411072uveal
vac86537142v_ac
vagal94613632vagal
vails85825932vails
vain75233002vain
vair75624142vair
vale74937342v_ale
van66246332v_an
var66148332v_ar
vas67755772v_as
vasal85516292vasal
vat67863452v_at
vau66840872v_au
vav95829432v_av
vaw95937462v_aw
veals84926192veals
vealy115817772vealy
veil75523592veil
veinal93812962veinal
vela75725542vela
venal85523212venal
venial94218282venial
viable111613772viable
viably14199832viably
vialed105112592vialed
viand9511072viand
vibe95124502vibe
vicar10513862vicar
vice95732852vice
vid77241802vi_d
vide85432752vide
vids85627532vids
vie65447632vi_e
vied86328632vied
vier75428152vier
vies75238622vies
view105917672view
vig75637522vi_g
viga85622962viga
vigas94817882vigas
vigil94313002vigil
vigs85427272vigs
vile76139802vile
villa85321232villa
villi86517852villi
vills86429322vills
vim87437022vi_m
vims95423312vims
vina76331802vina
vinals94716482vinals
vinas85126342vinas
vine75643682vine
vineal94814742vineal
vino76128432vino
viny106025952viny
vinyl115311622vinyl
viola85915542viola
viols86118102viols
virls85618602virls
vis66747612vi_s
visa76323872visa
visas84317652visas
vise75632672vise
visual938802visual
vita75828522vita
vitae84217632vitae
vitals94514302vitals
viva106119092viva
vivas114815022vivas
vive105426622vive
vocal104715642vocal
voila84813942voila
wail75238822wail
weal75838682weal
will75737512will
yill75628972yill
zeal135530332zeal
zill135727612zill

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.0931921408.6
2DLD Change Limit298722010.90632971.3
3Display Results2012010.0464369.6
 (SQL Overall)1786912011.045170996.2
 
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.