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

195 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
billions10221179(None) 
billion92212171billion_
billons93013361bill_ons
bullions101710041bullions
jillions15178281jillions
millions101712431millions
pillions101610921pillions
zillions17168071zillions
ballons93916962ball_ons
balloons103110512balloons
bazillions2143092bazillions
bilious9310932bi_lious
billies93923502billi_es
billing103823852billi_ng
billings113412632billings
billionth1444162billionth
billionths1553042billionths
billon83713832bill_on_
billows123611292bill_ows
bullion91911032bullion_
cullions10219222cullions
hellions11310022hellions
jillion14188932jillion_
million91813142million_
mullions101910352mullions
pillion92011702pillion_
trillions947182trillions
zillion16188772zillion_
aiblins9311473aibli_ns
ailerons849843ailerons
antlions839193antlions
ballies93725743balli_es
balling104424763balli_ng
ballon84117493ball_on_
balloon93711433balloon_
ballots94116033ball_ots
basions94213953b_asions
bastions10411693bastions
bazillion2043273bazillion_
bellboys1544523bellboys
bellhops1544873bellhops
bellies94023723belli_es
belling103825073belli_ng
bellings113811153bellings
bellows124313303bell_ows
belons84119413b_el_ons
berlins93216013berli_ns
bialies93618413biali_es
bialis83617163biali__s
biblists1236873biblists
bicrons113410473bi_crons
biffins15358533biffi_ns
biggins113410693biggi_ns
bilbies114712343bilbi_es
bilboas11438733bi_lboas
bilboes114410243bi_lboes
bilbos105011203bi_lbo_s
bilections14136503bilections
bilging114212683bilgi_ng
bilking144413553bilki_ng
billabong1441963billabong
billabongs1551533billabongs
billbugs1342703billbugs
billers94720833bill_ers
billets94516153bill_ets
billfold1443153billfold
billfolds1542773billfolds
billhook1743653billhook
billhooks1843233billhooks
billiard1145873billiard
billiards1245023billiards
billie85019173billi__e
billow114111223bill_o_w
billowy15366903bill_owy
bills75632863bill___s
billycans1642873billycans
biltong1034683bi_ltong
biltongs1133813bi_ltongs
biotins93114453bioti_ns
biotrons1037233biotrons
birling104317053birli_ng
birlings11359613birlings
bisons83914373bi__sons
blains84516373b_lai_ns
blazons1836163b_lazons
bolling103820883bolli_ng
bollixes1747203bollixes
bolsons969483b_olsons
bouillons1143603bouill_ons
brilliant1145683brilliant
brilliants1243073brilliants
brillos9369183brill_o_s
bulldogs1274243bulldogs
bullhorns1443963bullhorns
bullies94121893bulli_es
bulling104324793bulli_ng
bullous9311663bull_ous
bullpens1254083bullpens
bunions92210473b_unions
collins93419833colli_ns
cotillions1244783cotillions
cullion91910233cullion_
decillions1345433decillions
dictions111812673dictions
dilations102614453dilations
dillies84122163dilli_es
dilutions10248583dilutions
diluvions13224443diluvions
dislimns1144813dislimns
elisions82210423elisions
fictions132410743fictions
fillies103420253filli_es
filling113520803filli_ng
fillings122910503fillings
fillips12298133filli_ps
fillos94415083fill_o_s
fissions1138033fissions
galleons9258433galleons
galliots9228683galliots
gallons83015953gall_ons
galloons9289693galloons
gazillions2042703gazillions
gillies84120963gilli_es
gilling93520383gilli_ng
hellion10311133hellion_
hilling113821773hilli_ng
hilloas104413553hill_oas
hilloes103815963hill_oes
hilloing12158303hilloing
hillos94618893hill_o_s
hilltops1344933hilltops
illations9311393_illations
illites72415013_illites
illusions946213_illusions
inions64417003_i_nions
kazillions2352513kazillions
killicks1354873killicks
killies113318113killi_es
killing123118723killi_ng
killings133710483killings
killjoys2242033killjoys
kilotons1286313kilotons
lions55923213___lions
milliers102611903milliers
millimes122411373millimes
milline92519113milli_ne
millines102718063millines
milling103223683milli_ng
millings113712583millings
milliohm1544443milliohm
milliohms1643673milliohms
millionth1444793millionth
millionths1543243millionths
millpond1344143millpond
millponds1443503millponds
millruns1043643millruns
minions93314623mi_nions
mirlitons1144113mirlitons
missions10311903missions
modillions1343683modillions
mullion91911173mullion_
nilling83619563nilli_ng
nonillions1045263nonillions
oblivions1443243oblivions
octillions1243613octillions
pilling103722563pilli_ng
pillows122610123pill_ows
pinions93413603pi_nions
pulsions1037713pulsions
rebellions1244203rebellions
rilling84023623rilli_ng
scallions1145783scallions
scullions1154683scullions
silicons10107163silicons
sillies73425083silli_es
simlins9311843simli_ns
sirloins836723sirloins
solions7513753_solions
stallions946073stallions
talions7314103_talions
tiglons837343tigl_ons
tilling83522783tilli_ng
tillites8312833tillites
trillion847973trillion_
vibrions1345093vibrions
villains1138003villains
villeins1136043villeins
villous102810023vill_ous
violins10311453violi_ns
virions1039873vi_rions
visions10311023vi_sions
willies103920153willi_es
willing113821613willi_ng
willows13299753will_ows
zillionth2152703zillionth

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621957.42319690.4
3Display Results1951950.0633095.2
 (SQL Overall)1786911957.65923330.9
 
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.