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

139 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
viols8611810(None) 
diols65521011diols
vials85822381vials
vills86429321vills
viol76523591viol_
viola85915541viola
violas93713521violas
virls85618601virls
ails45654712ai_ls
aioli5318312aioli
aiolis6316842aiolis
avions94114392avions
awols84713522awols
bills75632862bills
biogs85016112biogs
bios66335322bio_s
birls74023162birls
boils75427192boils
cibols1039522cibols
cions75222852cions
coils75030082coils
cols66553082_cols
cools75632632cools
dials64925342dials
dills65530972dills
diol57329132diol_
dirls64720502dirls
dols56943052_dols
enols54718402enols
evils84114262evi_ls
fills84632372fills
filos86125382filos
fils75838692fi_ls
foils85025812foils
fools86824202fools
gaols66717572gaols
gills64728192gills
girls64518392girls
hills85431352hills
hols76946292_hols
idols65514132idols
ills47030422_ills
ions46737852_ions
jills125122822jills
kills94526172kills
kilos95021472kilos
lilos55821872lilos
lions55923212lions
mills75435052mills
milos75428012milos
mils66045332mi_ls
moils76125752moils
mols65948572_mols
mools76027172mools
nicols8810242nicols
nills54926672nills
nils46132452ni_ls
noils55024332noils
obols73715862obols
oils46337972oi_ls
pills74130972pills
pions75826392pions
pious74621272pious
pols66044562_pols
pools74427702pools
rials55026672rials
riels55121332riels
rills55032712rills
riots54922012riots
roils54826792roils
sials54227242sials
sills55135992sills
silos56029432silos
soils55327982soils
sols45448162_sols
thiols95112762thiols
tills54631712tills
tils45739612ti_ls
tirls54519802tirls
toils54527492toils
tools55325242tools
triols66117802triols
vails85825932vails
veals84926192veals
veils84918802veils
vial76731092vial_
vibes104719952vibes
vices105725532vices
vids85627532vi_ds
viers85621952viers
vies75238622vi_es
views11489642views
vigas94817882vigas
vigils104210192vigils
vigors102911482vigors
vigs85427272vi_gs
vile76139802vi_le
vill75235072vi_ll
villa85321232villa
villas96117262villas
villi86517852villi
villus93611222villus
vims95423312vi_ms
vinals94716482vinals
vinas85126342vinas
vines85137642vines
vinos84723072vinos
vinous93914172vinous
vinyls12467002vinyls
violet92620922violet
violets102210002violets
violin9311982violin
violins10311452violins
violist10312142violist
vires84529682vires
virl76224472virl_
virus85316842virus
vis66747612vi__s
visas84317652visas
vises84427772vises
visors92912222visors
vitals94514302vitals
vivas114815022vivas
vizors18328902vizors
voes75432822v_oes
voids95414672voids
voila84813942voila
voile84719722voile
voiles94616442voiles
vole75236982v_ole
voles86234042v_oles
volt76439532v_olt
volts85421292v_olts
vows106626942v_ows
vrows116115262vrows
wills84528962wills
wools84421462wools
yills83921552yills
zills144020782zills

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.0931921408.6
2DLD Change Limit538001391.56334421.0
3Display Results1391390.0463021.7
 (SQL Overall)1786911391.702104988.8
 
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.