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

544 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
villus9361122(None) 
villas96117261villas
villous102810011villous
vills86429321vill_s
bills75632862bill_s
callus85317072callus
dills65530972dill_s
filles94224522filles
fillos94415072fillos
fills84632372fill_s
gallus74313202gallus
gills64728192gill_s
hillos94618882hillos
hills85431352hill_s
hilus84817642hi_lus
iglus6609932_iglus
ileus54616892_ileus
ills47030422_ill_s
jills125122822jill_s
kills94526172kill_s
milles84526562milles
mills75435052mill_s
nills54926672nill_s
pilaus84114132pilaus
pileus84514942pileus
pills74130972pill_s
pilous84717752pilous
pilus75921062pi_lus
rilles64725502rilles
rills55032712rill_s
sills55135982sill_s
tills54631702till_s
valgus1047102valgus
vellum1136772vellum
vellums1235292vellums
vials85822382vial_s
vill75235072vill__
villa85321232vill_a
villae95615382villae
villi86517852vill_i
villose1038052villose
vinous93914172vinous
violas93713522violas
viols86118102viol_s
virls85618602virl_s
virtus94310142virtus
virus85316842vi_rus
viscus11428502viscus
vitellus1144142vitellus
vulgus1035782vulgus
wills84528962will_s
yills83921552yill_s
zills144020782zill_s
ails45654713ai_l_s
aiolis6316843aiolis
airbus848343airbus
aisles64721143aisles
alls46740923_all_s
axillas14278963axillas
bacillus1245153bacillus
balls76236413ball_s
belles85325993belles
bells76432163bell_s
bialis83617163bialis
bialys11387913bialys
bibles104617643bibles
bields94110003bields
bijous1548043bijous
bilbos105011193bilbos
biles75542143bi_les
bilges94915633bilges
bilious9310933bilious
bilks115117893bi_lks
bill67239933bill__
billbug1242753billbug
billbugs1342693billbugs
billed94224903billed
biller84923483biller
billers94720823billers
billet86029723billet
billets94516153billets
billie85019173billie
billies93923503billies
billon83713823billon
billons93013353billons
billow114111223billow
billows123611283billows
billy105525363bill_y
birles84920643birles
birls74023163birl_s
bolls75531313boll_s
bolus79125543_bolus
brillos9369173brillos
brills84916293brill_s
bullous9311663bullous
bulls75629573bull_s
callas84526753callas
callous93516593callous
calls75634733call_s
cellos84517803cellos
cells75428063cell_s
chillis124411603chillis
chills114717703chill_s
chillum1435443chillum
chillums1544163chillums
cilium104311373cilium
circus104310593circus
cirrus8349173cirrus
cistus84611343cistus
citrus83610913citrus
coleus86818273coleus
cullis84115993cullis
culls75425813cull_s
cultus85110733cultus
dalles74222063dalles
dells66630943dell_s
dials64925343dial_s
dildos8179303dildos
dill55239973dill__
dilled84122223dilled
dillies84122153dillies
dilly94923783dill_y
dingus83611843dingus
diols65521013diol_s
dirls64720503dirl_s
discus94512113discus
dolls66126923doll_s
drills74414203drill_s
dulls64523743dull_s
ells46431353_ell_s
eviller1056673eviller
evillest1146353evillest
evilly1236593evill_y
evils84114263evi_l_s
failles102914123failles
falls85727653fall_s
fellas95116963fellas
fells85327383fell_s
fichus14388113fichus
ficus105015493fi_cus
fields104211043fields
filers94623723filers
files85441273fi_les
filets94718953filets
fill75540193fill__
fille84327403fill_e
filled104922263filled
filler94623623filler
fillers104320203fillers
fillet95027083fillet
fillets103414753fillets
fillies103420253fillies
fillip11268953fillip
fillips12298133fillips
fillo84319783fill_o
filly114424903fill_y
filmis114610283filmis
films105617963fi_lms
filos86125383fi_los
fils75838693fi_l_s
filths12389783filths
filum105015433fi_lum
flus75626543__flus
folles93820473folles
follis93113903follis
frills94414223frill_s
fulls84623523full_s
gallous82813953gallous
galls64729323gall_s
gilds75417523gi_lds
gill56336183gill__
gilled84521633gilled
giller74519733giller
gillers84216893gillers
gillie74816943gillie
gillies84120963gillies
gilly94321633gill_y
gilts64924263gi_lts
girls64518393girl_s
grilles83715023grilles
grills74314803grill_s
gulls65222983gull_s
hallos95425103hallos
halls85633783hall_s
hallux1637363hallux
hellos95321683hellos
hells85032043hell_s
hiatus938223hiatus
hill76439493hill__
hilled104022223hilled
hiller94421633hiller
hillers103718723hillers
hillo84721653hill_o
hilloa94713033hilloa
hilloas104413543hilloas
hilloes103815943hilloes
hilly114422163hill_y
hilts86924413hi_lts
hilum105514603hi_lum
hollas94616903hollas
hollos95320633hollos
hullos94916293hullos
hulls84923563hull_s
ictus7249693_ictus
idles66720123_idles
iglu510814783_iglu_
ileum74512823_ileum
ilium74614173_ilium
ilks87218573_i_lks
ill37437093_ill__
iller54821293_iller
illest63615723_illest
illude7327503_illude
illudes8347553_illudes
illume8298223_illume
illumes9327673_illumes
illy76925333_ill_y
incus73315053_incus
isles54220563_isles
jellos134714283jellos
jells125522163jell_s
jill116430263jill__
jilts124717413ji_lts
kiblas1239323kiblas
kilims1277903kilims
kill85533173kill__
killed113918773killed
killer104917953killer
killers114215573killers
killie104114893killie
killies113318113killies
kilns95112983ki_lns
kilos95021473ki_los
kilts95122183ki_lts
krills104211283krill_s
kvells13346613kvell_s
lalls55324133lall_s
lapillus1043933lapillus
lieus56218483li_eus
lilacs837483lilacs
lilies63021413lilies
lilos55821873li_los
lilts55822803li_lts
limbus105710373limbus
limulus935083limulus
lisles63416283lisles
litmus836323litmus
lolls512121733loll_s
lulls54119653lull_s
lulus54315163_lulus
maills84215283maill_s
malleus92911313malleus
malls76233433mall_s
mells75031333mell_s
miaous8511693miaous
miauls8178713miauls
milds86422053mi_lds
milers84625163milers
miles74645073mi_les
milieus939803milieus
milium104712673milium
milks115020583mi_lks
mill66541473mill__
mille75029133mill_e
milled94326173milled
miller84625413miller
millers93621333millers
millet84030743millet
millets94216843millets
millrun944183millrun
millruns1043633millruns
milos75428013mi_los
milpas101710273milpas
mils66045323mi_l_s
milts75430713mi_lts
minus75223933mi_nus
missus85312293missus
molls75129783moll_s
mollusc11103093mollusc
mollusk13103123mollusk
mullas84215933mullas
mulls75124153mull_s
nidus65913573ni_dus
niellos736143niellos
nilgaus844003nilgaus
nill45634303nill__
nilled73919453nilled
nils46132453ni_l_s
nimbus10377273nimbus
nisus56014393ni_sus
nulls55019983null_s
obelus8348403obelus
obolus8378813obolus
ocellus935983ocellus
oculus8178393oculus
oilcup1044253oilcup
oilcups1143333oilcups
oilers64721193oilers
oils46337973oi_l_s
ollas54218283_ollas
palls74332563pall_s
palpus104210283palpus
peplus10138343peplus
phallus1236063phallus
piculs103511753piculs
pignus937953pignus
pilafs113511023pilafs
pilau73618523pilau_
pilaws11399433pilaws
pileous9510523pileous
piles74742613pi_les
pileum10399513pileum
pileup10437923pileup
pileups11365433pileups
pilis75825203pi_lis
pill65339463pill__
pillar8314023pillar
pillars9313483pillars
pilled94222753pilled
pillow113110573pillow
pillows122610103pillows
pilots84018873pilots
pilule8411123pilule
pilules9510623pilules
pious74621273pi_ous
plus66324833__plus
poilus82210573poilus
polls74627723poll_s
prills84015613prill_s
pulls74425053pull_s
pullup1045893pullup
pullups1134233pullups
pulvillus1451503pulvillus
quills153811843quill_s
railbus934413railbus
rials55026673rial_s
rictus8379193rictus
riels55121333riel_s
rifles94217703rifles
riles55343643ri_les
rill45140903rill__
rille55728733rill_e
rilled74525653rilled
rillet64828853rillet
rillets74216153rillets
rimous8311913rimous
risus54216393ri_sus
rolls55326233roll_s
scillas9310463scillas
selles64426983selles
sells55134433sell_s
shills94519603shill_s
sials54227243sial_s
sidles74721153sidles
siglos7311463siglos
siglum936563siglum
silds65520523si_lds
silenus7369693silenus
silks94620683si_lks
sill45545153sill__
siller64026053siller
sillers73822093sillers
sillies73425073sillies
silly84527613sill_y
silos56029423si_los
silts55330823si_lts
silvas92912183silvas
sinus55523853si_nus
situs55019233si_tus
skills104313913skill_s
soleus64615613soleus
solus54726983_solus
spills84717453spill_s
stills64118563still_s
stylus9397463stylus
sulcus8410493sulcus
sulus54821883_sulus
swills94213353swill_s
tailles72516463tailles
tallis63319963tallis
talls55133433tall_s
talus55423263_talus
tells55828943tell_s
tellys9348843tellys
thallus1035603thallus
thills95515383thill_s
tilaks1097353tilaks
tildes74513963tildes
tilers63523493tilers
tiles55542103ti_les
till45941203till__
tilled74722953tilled
tiller64222533tiller
tillers73418733tillers
tils45739613ti_l_s
tilths9459373tilths
tilts55325613ti_lts
tirls54519803tirl_s
titles63719923titles
tolls54728433toll_s
tolus55024483_tolus
trills64319853trill_s
tuilles72411923tuilles
tulles63218893tulles
twills9489793twill_s
ulus45622563__ulus
vagus96713813v_agus
vails85825933vail_s
vales85434263v_ales
valets93715623valets
valley124311603valley
valleys13407483valleys
valors93413773valors
valour93010373valour
valours10248733valours
valses94514613valses
value85719093v_alue
values94314943values
valves124113783valves
vanillas11228123vanillas
varus85921183v_arus
vatus86114643v_atus
vaults94511673vaults
vaus75928923v__aus
veals84926193veal_s
veilers103911823veilers
veils84918803veil_s
velars93913723velars
velds95615583v_elds
veldts10417753veldts
velour9328763velour
velours10278083velours
velum10713383v_elum
venous93713193venous
venus84918903v_enus
versus94211143versus
vertus94613603vertus
vexillum2042113vexillum
vial76731093vial__
vialed105112593vialed
vialled1156843vialled
viands1047813viands
vibes104719953vi_bes
vicars11712263vicars
vices105725533vi_ces
vicious1239493vicious
videos104911373videos
vids85627533vi__ds
viers85621953vi_ers
vies75238623vi__es
views11489643vi_ews
vigas94817883vi_gas
vigias104110893vigias
vigils104210193vigils
vigors102911483vigors
vigour10256803vigour
vigours11285483vigours
vigs85427273vi__gs
vile76139803vi_l_e
vilely1239443vilely
viler86324163vi_ler
vilest9416843vilest
vilify1536773vilify
village113610823village
villages123010593villages
villain1038473villain
villains1137993villains
villein1036753villein
villeins1136033villeins
villously1544533villously
vims95423313vi__ms
vinals94716483vinals
vinas85126343vi_nas
vincas113912453vincas
vines85137643vi_nes
vinos84723073vi_nos
vinyls12467003vinyls
viol76523593viol__
viola85915543viol_a
violet92620923violet
violets102210003violets
violin9311983violin
violins10311453violins
violist10312143violist
vipers114914533vipers
vireos94212453vireos
vires84529683vi_res
virgas1048883virgas
virl76224473virl__
virtu85314093virtu_
virtue9358673virtue
virtues10338023virtues
vis66747613vi___s
visas84317653vi_sas
viscous1238833viscous
vises84427773vi_ses
visits9311423visits
visors92912223visors
vistas94513273vistas
vitals94514303vitals
vittles103211113vittles
vivas114815023vi_vas
vivers124717363vivers
vixens16286203vixens
vizirs18306713vizirs
vizors18328903vizors
vizslas1943143vizslas
vodous1038593vodous
voiles94616443voiles
voles86234043v_oles
volley12419743volley
volleys13316643volleys
voltes94915583voltes
volts85421293v_olts
volvas12447993volvas
volvulus1441933volvulus
vulvas12388843vulvas
wallas95719393wallas
walls85529383wall_s
walrus956433walrus
wells85426193well_s
wields10469623wields
wilds94818203wi_lds
wiles85437873wi_les
wilful1235963wilful
will75737513will__
willed104722453willed
willer94021063willer
willers103517903willers
willet95124833willet
willets104414323willets
willful1344533willful
willie94116453willie
willies103920153willies
willow12369693willow
willows13299743willows
willy115321913will_y
wilts85023503wi_lts
yells85821943yell_s
yields10466843yields
yill75628973yill__
zill135727613zill__
zillah1836563zillah
zillahs1935383zillahs

Search took 9 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 Filter1786911127160.266671770.7
2DLD Change Limit1127165447.89014285.9
3Display Results5445440.1733144.5
 (SQL Overall)1786915448.32921454.1
 
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.