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

276 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
villous10281002(None) 
villus93611221vill_us
bilious9310932bilious
billons93013362billons
billows123611292billows
bullous9311662bullous
callous93516602callous
fillos94415082fillo_s
gallous82813952gallous
hilloas104413552hilloas
hilloes103815962hilloes
hillos94618892hillo_s
pileous9510522pileous
pillows122610122pillows
pilous84717752pi_lous
vicious1239492vicious
villas96117262vill_as
villose1038052villose
villously1544532villously
vills86429322vill__s
vinous93914172vi_nous
viscous1238832viscous
willows13299752willows
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
ballons93916963ballons
ballots94116033ballots
bellows124313303bellows
bibulous1244633bibulous
bijous1548043bi_jous
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilbo_s
billbug1242753billbug
billbugs1342703billbugs
billers94720833billers
billets94516153billets
billies93923503billies
billions102211793billions
billon83713833billo_n
billow114111223billo_w
billowy15366903billowy
bills75632863bill__s
brillos9369183brillo_s
bulbous1138293bulbous
callus85317073call_us
cellos84517803cello_s
chylous15107273chylous
cirrous93111063cirrous
citrous93112993citrous
collops112611753collops
dialogs938103dialogs
diglots9299503diglots
dildoes9229243dildoes
dildos8179303dildo_s
dillies84122163dillies
dills65530973dill__s
diploes101111493diploes
dollops10287963dollops
emulous937343emulous
fallout10313503fallout
fallouts1137883fallouts
fallows133713973fallows
felloes104114383felloes
fellows134212433fellows
fibrous1237593fibrous
fillers104320213fillers
filles94224523fill_es
fillets103414753fillets
fillies103420253fillies
fillips12298133fillips
fillo84319783fillo__
fills84632373fill__s
filos86125383fi_lo_s
folious103710733folious
follows13409923follows
fulvous1334543fulvous
gallons83015953gallons
gallops103211653gallops
gallows113513513gallows
gallus74313203gall_us
gibbous1265333gibbous
giglots9367863giglots
gillers84216903gillers
gillies84120963gillies
gills64728193gill__s
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
helloes103717463helloes
hellos95321683hello_s
hideous1168433hideous
hillers103718733hillers
hillo84721653hillo__
hilloa94713033hillo_a
hillock1646693hillock
hillocks1736063hillocks
hilloed113211293hilloed
hills85431353hill__s
hilltops1344933hilltops
hilus84817643hi_l_us
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
igloos738033_igloos
iglus6609933_igl_us
ileus54616893_i_leus
ills47030423_ill__s
iodous7311503_iodous
jealous1438093jealous
jellos134714283jello_s
jillions15178283jillions
jills125122823jill__s
killers114215583killers
killies113318113killies
killjoys2242033killjoys
killock1255253killock
killocks1354793killocks
kills94526173kill__s
kilos95021473ki_lo_s
libellous1143633libellous
libelous1047193libelous
lilos55821873li_lo_s
lollops9227443lollops
maillots1037473maillots
malleus92911313malleus
mallows123714323mallows
mellows123812233mellows
miaous8511693mi_aous
milieus939803milieus
millers93621343millers
milles84526563mill_es
millets94216843millets
millhouse1443903millhouse
millions101712433millions
millrun944183millrun
millruns1043643millruns
mills75435053mill__s
milos75428013mi_lo_s
niellos736143niello_s
nilgaus844003nilgaus
nills54926673nill__s
nimious937663nimious
niobous936333niobous
nitrous73512483nitrous
niveous1037193niveous
pallors9314363pallors
parlous9414293parlous
pavillons1443573pavillons
piceous11310693piceous
pilaus84114133pi_laus
pileus84514943pi_leus
pillars9313493pillars
pillions101610923pillions
pillory12247453pillory
pillow113110573pillo_w
pillowy15316423pillowy
pills74130973pill__s
pilots84018873pi_lots
pilus75921063pi_l_us
pious74621273pi__ous
pistous92714383pistous
piteous9310683piteous
pullout9310593pullout
pullouts1045223pullouts
pulpous1177013pulpous
rilles64725503rill_es
rillets74216153rillets
rills55032713rill__s
rimous8311913ri_mous
riotous739863riotous
rollout7811943rollout
rollouts8136733rollouts
sallows103915553sallows
sellout7313583sellout
sellouts837493sellouts
siglos7311473siglo_s
silenus7369693silenus
sillers73822103sillers
sillies73425083sillies
sills55135993sill__s
silos56029433si_lo_s
simious939803simious
sinuous739063sinuous
talcous939483talcous
tallols73311363tallols
tallows103313743tallows
thallous1136523thallous
tiglons837343tiglons
tillers73418743tillers
tills54631713till__s
timeous938403timeous
vacuous1237023vacuous
valgus1047103v_algus
valleys13407483valleys
valorous1147373valorous
valors93413773v_alors
valour93010373v_alour
valours10248743v_alours
variolous1244983variolous
various103113103various
vellum1136773vell_um
vellums1235293vellums
velour9328763v_elour
velours10278083v_elours
venous93713193v_enous
venulous1145713venulous
vials85822383vial__s
viators102712023viators
victors123311183victors
videos104911373video_s
vigorous1245763vigorous
vigors102911483vi_gors
vigour10256803vi_gour
vigours11285483vi_gours
vill75235073vill___
villa85321233vill__a
villadoms1542343villadoms
villae95615383vill_ae
village113610833village
villages123010603villages
villain1038473villain
villainous1352553villainous
villains1138003villains
villein1036753villein
villeins1136043villeins
villi86517853vill__i
vinos84723073vi_no_s
violas93713523viol_as
violets102210003violets
violins10311453violins
violone1037153violone
violones1137383violones
viols86118103vi__ols
viperous1347613viperous
vireos94212453vireo_s
virions1039873virions
virls85618603virl__s
virtuous1144663virtuous
virtus94310143vi_rtus
virus85316843vi__rus
viscus11428503vi_scus
visions10311023visions
visors92912223vi_sors
vitellus1144143vitellus
vitreous1145843vitreous
vizors18328903vi_zors
vodous1038603v_odous
volleys13316643volleys
vulgus1035783v_ulgus
wallops123410413wallops
wallows133613533wallows
willers103517913willers
willets104414323willets
willful1344533willful
willies103920153willies
willow12369693willo_w
willowy16276353willowy
wills84528963will__s
yellows13329603yellows
yills83921553yill__s
zealous1637813zealous
zillahs1935383zillahs
zillions17168073zillions
zills144020783zill__s
zincous1837053zincous

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.1431249587.4
2DLD Change Limit1340272766.37321030.4
3Display Results2762760.0932967.7
 (SQL Overall)1786912766.60927037.5
 
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.