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

166 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
vials8582238(None) 
dials64925341dials
rials55026671rials
sials54227241sials
vails85825931vails
veals84926191veals
vial76731091vial_
vills86429321vills
vinals94716481vinals
viols86118101viols
virls85618601virls
vitals94514301vitals
aals49941142_aals
ails45654712ai_ls
als36663022__als
avails939692avails
avians93711562avians
baals76122702baals
bails75933522bails
bals66354042_bals
biali73419072biali
bialis83617162bialis
bialy105119322bialy
bialys11387912bialys
bias64738152bia_s
bills75632862bills
birls74023162birls
coals76129602coals
dals57145122_dals
deals65435342deals
dhals95415442dhals
dial55935062dial_
dills65530972dills
diols65521012diols
dirls64720502dirls
duals65620082duals
evils84114262evi_ls
fails85631482fails
fiars86720832fiars
fiats85324482fiats
fills84632372fills
fils75838692fi_ls
finals94316162finals
foals85721692foals
gals57946502_gals
gavials1136602gavials
gills64728192gills
girls64518392girls
goals65521292goals
hails85231642hails
heals85733452heals
hills85431352hills
ills47030422_ills
jails125422942jails
jills125122822jills
kails95525212kails
kills94526172kills
liars54723162liars
mails76037772mails
meals75933372meals
miauls8178712miauls
mills75435052mills
mils66045322mi_ls
nails55730402nails
nills54926672nills
nils46132452ni_ls
oils46337972oi_ls
opals75718352opals
orals55826482orals
ovals85413392ovals
pails75833062pails
pals66951352_pals
peals75235492peals
phials1158872phials
pial65636702pial_
pians75126962pians
pias66542552pia_s
pibals103813082pibals
pills74130972pills
pipals104213642pipals
rails55937402rails
reals55038652reals
rial45938092rial_
rias45540592ria_s
riels55121332riels
rills55032712rills
rivals94213182rivals
riyals94111082riyals
sails55738102sails
sals46851672_sals
seals54839692seals
sial45938832sial_
sills55135982sills
sisals63013572sisals
tails55634192tails
teals56234132teals
ticals83214712ticals
tills54631702tills
tils45739612ti_ls
tirls54519802tirls
trials64319882trials
urials64415192urials
vacs96226202v_acs
vail75432552vail_
vairs85019132vairs
vale74937342v_ale
vales85434262v_ales
valse85117522v_alse
vans76236722v_ans
vars75742072v_ars
vas67755772v_a_s
vats76841742v_ats
vaus75928922v_aus
vavs105720432v_avs
vaws105527322v_aws
veal76936812veal_
vealy115817772vealy
veils84918802veils
via65636242via__
viable111613772viable
viably14199832viably
vialed105112592vialed
viand9511072viand
viands1047812viands
vibes104719952vibes
vicars11712262vicars
vices105725532vices
vids85627532vi_ds
viers85621952viers
vies75238622vi_es
views11489642views
vigas94817882vigas
vigils104210192vigils
vigs85427272vi_gs
vile76139802vi_le
vill75235072vi_ll
villa85321232villa
villas96117262villas
villi86517852villi
villus93611222villus
vims95423312vi_ms
vinal85725812vinal_
vinas85126342vinas
vines85137642vines
vinos84723072vinos
vinyls12467002vinyls
viol76523592viol_
viola85915542viola
violas93713522violas
viral86419592viral_
vires84529682vires
virl76224472virl_
virus85316842virus
vis66747612vi__s
visas84317652visas
vises84427772vises
visuals1036852visuals
vital84819672vital_
vivas114815022vivas
vocals113811582vocals
wails86631482wails
weals85428742weals
wills84528962wills
yills83921552yills
zeals145320852zeals
zills144020782zills

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.1731032896.0
2DLD Change Limit538001661.98327130.6
3Display Results1661660.0463608.7
 (SQL Overall)1786911662.20281149.4
 
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.