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

168 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
bullions10171004(None) 
billions102211791billions
bullion91911031bullion_
cullions10219221cullions
mullions101910351mullions
ballons93916962ball_ons
balloons103110512balloons
billion92212172billion_
billons93013362bill_ons
bulldogs1274242bulldogs
bullhorns1443962bullhorns
bullies94121892bulli_es
bulling104324792bulli_ng
bullous9311662bull_ous
bullpens1254082bullpens
bunions92210472bu_nions
cullion91910232cullion_
hellions11310022hellions
jillions15178282jillions
millions101712432millions
mullion91911172mullion_
pillions101610922pillions
pulsions1037712pulsions
scullions1154682scullions
zillions17168072zillions
ablutions1146593ablutions
abutilons1142963abutilons
antlions839193antlions
auctions104012143auctions
avulsions1243263avulsions
ballies93725743balli_es
balling104424763balli_ng
ballon84117493ball_on_
balloon93711433balloon_
ballots94116033ball_ots
basions94213953b_asions
bastions10411693bastions
bazillions2143093bazillions
bellboys1544523bellboys
bellhops1544873bellhops
bellies94023723belli_es
belling103825073belli_ng
bellings113811153bellings
bellows124313303bell_ows
belons84119413b_el_ons
berlins93216013berli_ns
bilious9310933b_ilious
billies93923503billi_es
billing103823853billi_ng
billings113412633billings
billionth1444163billionth
billionths1553043billionths
billon83713833bill_on_
billows123611293bill_ows
blains84516373b_lai_ns
blazons1836163b_lazons
bolling103820883bolli_ng
bollixes1747203bollixes
bolsons969483b_olsons
bouillons1143603bouillons
buffoons1643093buffoons
bugling113615343bugli_ng
bugloss1035893bugl_oss
bulbils11338333bulbi_ls
bulbous1138293bu_lbous
bulging113514213bulgi_ng
bulking143815123bulki_ng
bullaces12299433bullaces
bullbats1255893bullbats
bulldog1174253bulldo_g
bulldoze2043053bulldoze
bulldozes2143053bulldozes
bulletins1146333bulletins
bullets93516393bull_ets
bullfrogs1542323bullfrogs
bullhorn1344463bullhorn
bullied104514813bulli_ed
bullier94116433bulli_er
bulliest104314493bulliest
bullish12511193bulli_sh
bullnose1044553bullnose
bullnoses1144703bullnoses
bullock1537193bull_ock
bullocks1636293bullocks
bullpen1135193bullpen_
bullpout1245783bullpout
bullpouts1343193bullpouts
bullring11388423bullring
bullrings12314623bullrings
bulls75629573bull___s
bullshots1443173bullshots
bullyboys1942263bullyboys
bullying14329293bullying
bumkins15318013bumki_ns
bunion83111313bu_nion_
burgeons1146053burgeons
burins84221893bu_ri_ns
burling104421133burli_ng
burtons9310853bu_rtons
buskins133310943buski_ns
butling103516813butli_ng
buttons9310333bu_ttons
collins93419833colli_ns
cullies94419963culli_es
culling103921303culli_ng
cullis84115993culli__s
cullises103111313cullises
cushions1335693cushions
dulling93418273dulli_ng
dunlins849553dunli_ns
durions839963du_rions
ebullient1153953ebullient
ebullitions1352363ebullitions
elusions82610083elusions
elutions82513053elutions
emulsions1145343emulsions
evulsions1254573evulsions
fluxions1844423fluxions
fulling114019703fulli_ng
fusions1039153fu_sions
galleons9258433galleons
galliots9228683galliots
gallons83015953gall_ons
galloons9289693galloons
gullies84717313gulli_es
gulling94019563gulli_ng
hellion10311133hellion_
hulling113619013hulli_ng
hulloas103911913hull_oas
hulloes104113923hull_oes
hulloing12146703hulloing
hulloos104010073hull_oos
hullos94916293hull_o_s
jillion14188933jillion_
lions55923213___lions
lulling83616803lulli_ng
million91813143million_
mulleins10277053mulleins
mullens93611313mull_ens
mulligans1244773mulligans
mulling103819993mulli_ng
mullioned1245733mullioned
mullites10411643mullites
munnions1035273munnions
muslins9312213musli_ns
nucleons1065483nucleons
nulling83818063nulli_ng
pillion92011703pillion_
pulling103821073pulli_ng
pullmans1253933pullmans
pulsion938393pulsion_
purlins93415423purli_ns
purloins1077033purloins
rebellions1244203rebellions
ructions102811683ructions
scallions1145783scallions
scullion1065633scullion_
solions7513753_solions
stallions946073stallions
suasions838783suasions
suctions103012903suctions
sullies74122223sulli_es
talions7314103_talions
trillions947183trillions
tuitions838283tuitions
turions7311573tu_rions
unions64216753_u_nions
zillion16188773zillion_

Search took 10 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.216827273.1
2DLD Change Limit1461621688.86016496.8
3Display Results1681680.0762210.5
 (SQL Overall)1786911689.15219524.8
 
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.