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 “billiont” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
billion92212171billion_
billions102211791billions
billionth1444161billionth
billing103823852billi_ng
billionths1553042billionths
billon83713832bill_on_
billons93013362bill_ons
brilliant1145682brilliant
bullion91911032bullion_
bullions101710042bullions
jillion14188932jillion_
jillions15178282jillions
million91813142million_
millions101712432millions
millionth1444792millionth
pillion92011702pillion_
pillions101610922pillions
zillion16188772zillion_
zillions17168072zillions
zillionth2152702zillionth
balling104424763balli_ng
ballon84117493ball_on_
ballonet10314503ball_onet
ballons93916963ball_ons
balloon93711433balloon_
balloons103110523balloons
ballot84624093ball_o_t
ballpoint1345993ballpoint
bazillion2043273bazillion_
bazillions2143093bazillions
belling103825073belli_ng
bellwort1348773bellwort
biblist11310833bibli_st
bilgiest11309883bilgiest
bilging114212683bilgi_ng
bilious9310933bi_lious
bilking144413553bilki_ng
billabong1441963billabong
billet86029723bill__et
billfold1443153billfold
billhook1743653billhook
billiard1145873billiard
billie85019173billi__e
billies93923503billi_es
billings113412633billings
billow114111223bill_o_w
billows123611293bill_ows
billowy15366903bill_owy
biltong1034683bi_ltong
biont7727163b___iont
birling104317053birli_ng
bolling103820883bolli_ng
brilliants1243073brilliants
bulliest104314503bulliest
bulling104324793bulli_ng
bullpout1245783bullpout
cullion91910233cullion_
cullions10219223cullions
diplont10311693dipl_ont
ebullient1153953ebullient
filling113520803filli_ng
galliot82214133gallio_t
gilling93520383gilli_ng
hellion10311133hellion_
hellions11310023hellions
hilliest113914113hilliest
hilling113821773hilli_ng
hilloing12158303hilloing
illicit949833_illicit
killing123118723killi_ng
lilliput1044193lilliput
milline92519113milli_ne
milling103223683milli_ng
milliohm1544443milliohm
millionths1543243millionths
millivolt1444363millivolt
millpond1344143millpond
mullion91911173mullion_
mullions101910353mullions
nilling83619563nilli_ng
pilling103722563pilli_ng
rilling84023623rilli_ng
silliest84017103silliest
tilling83522783tilli_ng
trillion847973trillion_
trillions947183trillions
trillionth1362973trillionth
willing113821613willi_ng

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.440406115.9
2DLD Change Limit146162887.46619577.0
3Display Results88880.0332666.7
 (SQL Overall)178691887.93922508.0
 
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.