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

237 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
bilious931093(None) 
bijous1548042bi_jous
bilboas11438732bilboas
bilboes114410242bilboes
bilbos105011202bilbo_s
biliously1446662biliously
billions102211792billions
billons93013362billons
billows123611292billows
bulbous1138292bulbous
bullous9311662bullous
folious103710732folious
milieus939802milieus
nimious937662nimious
pileous9510522pileous
pilous84717752pil_ous
simious939802simious
vicious1239492vicious
villous102810022villous
ambitious1344613ambitious
anxious1437283anxious
bailies94120203baili_es
bailiffs1642563bailiffs
bailors93212413bail_ors
bailout9414133bail_out
bailouts1036613bail_outs
balboas113710073balboas
ballons93916963ballons
ballots94116033ballots
basions94213953basions
bayous11411153b_ayous
beliefs12448583beliefs
beliers94617383beliers
belies84631053beli_es
bellows124313303bellows
belons84119413bel_ons
belows114614183bel_ows
bialies93618413biali_es
bialis83617163biali__s
biblists1236873biblists
bibulous1244643bibulous
bicrons113410473bicrons
bidis86721153bidi__s
bifarious1443553bifarious
bigamous1385503bigamous
bigos85020013bi_go_s
bigots95015133bi_gots
bijou1458793bi_jou_
bijoux2253453bi_joux
bijugous1842223bijugous
bikies124515163biki_es
bikinis13346203bikinis
bilbies114712343bilbies
bilbo95513613bilbo__
bilboa10367843bilbo_a
biles75542143bil__es
bilges94915633bil_ges
biliary1238213biliary
bilkers134711863bilkers
bilks115117893bil__ks
billbug1242753billbug
billbugs1342703billbugs
billers94720833billers
billets94516153billets
billies93923503billies
billings113412633billings
billion92212173billio_n
billon83713833billo_n
billow114111223billo_w
billowy15366903billowy
bills75632863bil__ls
biltong1034683biltong
biltongs1133813biltongs
bimanous1245693bimanous
bimboes13498733bimboes
bimbos124610523bimbo_s
bingoes104013983bingoes
bingos95514793bingo_s
binits85716673bini_ts
binocs1039923bi_nocs
biogs85016113b__iogs
bios66335333b__io_s
biparous1246923biparous
bipods11408593bi_pods
biramous1266073biramous
birlings11359613birlings
biros75325133bi_ro_s
bishops1437033bishops
bisons83914373bi_sons
blimps12588153b_limps
blinds95111613b_linds
blinis85313683b_linis
blinks124613573b_links
blips95615783b_li_ps
bliss75616913b_li_ss
blites84721213b_lites
blobs95620033b_l_obs
blocs95219653b_l_ocs
blogs85319233b_l_ogs
bloods94614843b_loods
blooms104613173b_looms
bloops106611343b_loops
blots75626173b_l_ots
blouse84714723b_l_ouse
blousy11459123b_l_ousy
blows105423833b_l_ows
boletus948643boletus
bolides10515073bolides
bolos75531373bol_o_s
bolsons969483bolsons
bolus79125543bol__us
boubous1138693boubous
brillos9369193brillo_s
brios74725733b_rio_s
brumous11107443brumous
bullions101710043bullions
bunions92210473bunions
burnous938823burnous
bylines1239243bylines
callous93516603callous
carious93320283carious
cilices113814023cilices
cilium104311373cili_um
cirrous93111063cirrous
citrous93112993citrous
copious11311963copious
curious93813563curious
devious1138523devious
diclinous1244103diclinous
diecious1146873diecious
dildoes9229243dildoes
dildos8179303dildo_s
dioicous1145133dioicous
dubious1036893dubious
envious1037223envious
eximious1743873eximious
fibrous1237593fibrous
filings115213073filings
fillos94415083fillo_s
filos86125383fil_o_s
folios93915463folio_s
fulvous1334543fulvous
furious103110633furious
galiots82311323galiots
gallous82813953gallous
gibbous1265333gibbous
halitus10339963halitus
helios94816633helio_s
hideous1168433hideous
hilarious1244743hilarious
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
hilus84817643hil__us
idioms956413_idioms
idiots768643_idiots
ileus54616893_il_eus
iliads7448673_iliads
ilium74614183_ili_um
impious1137063impious
inions64417003_inions
iodous7311503_iodous
jillions15178283jillions
kilims1277903kili_ms
kilos95021483kil_o_s
lieus56218483__lieus
lilies63021413lili_es
lilos55821873lil_o_s
lions55923213__lions
miaous8511693mi_aous
milieu8314113milieu_
milieux1643783milieux
milium104712683mili_um
millions101712433millions
milos75428013mil_o_s
minibus1136343minibus
minions93314623minions
nilgaus844003nilgaus
niobous936333niobous
nitrous73512493nitrous
niveous1037193niveous
noxious1446563noxious
nubilous1044853nubil_ous
oblivious1443063oblivious
obvious1244823obvious
odious749933_odious
olios54520853_olio_s
osmious936003osmious
piceous11310693piceous
pilaus84114133pil_aus
pileus84514943pil_eus
pilings103313613pilings
pilis75825203pili__s
pillions101610933pillions
pillows122610123pillows
pilots84018873pil_ots
pilus75921063pil__us
pinions93413603pinions
pious74621273__pious
pistous92714383pistous
piteous9310683piteous
polios84019723polio_s
pulpous1177013pulpous
ricinus9408123ricinus
rimous8311913ri_mous
riotous739873riotous
rubious938283rubious
sanious7514103sanious
serious73616283serious
silenus7369693silenus
silicas9310603silicas
siliceous1145033siliceous
silicious1146433silicious
silicons10107163silicons
siliqua1643983siliqua
silique1645643silique
siliques1745353siliques
siliquous1843053siliquous
silos56029433sil_o_s
sinuous739063sinuous
solidus8338113solidus
solions7513753solions
talcous939483talcous
talions7314113talions
tedious838443tedious
tilings84212793tilings
timeous938403timeous
umbilicus1552013umbilicus
various103113103various
villus93611223vil_lus
vinous93914173vi_nous
virions1039873virions
viscous1238833viscous
visions10311023visions
willows13299753willows
zillions17168073zillions
zincous1837053zincous

Search took 8 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.420425454.8
2DLD Change Limit1340272377.26618445.8
3Display Results2372370.0763118.4
 (SQL Overall)1786912377.76223021.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.