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

115 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
bulkages153527(None) 
bulkage1435701bulkage_
boskages1565422boskages
brokages1536252brokages
bulges95919322bul__ges
bullaces12299432bullaces
buoyages1443802buoyages
burgages1236482burgages
sullages939972sullages
ullages838952_ullages
alkanes113812933_alkanes
anlages82414103anl_ages
baggages1335443baggages
balases93815433bal_ases
ballades114211643ballades
bandages12310633bandages
barrages11711083barrages
beldames1336803beldames
bilges94915633bil__ges
blades95221253b_l_ades
blames105121863b_l_ames
blares85021633b_l_ares
blazes174817353b_l_azes
blockages1844063blockages
bludges114511123b_ludges
blunges104212223b_lunges
bolases93315003bol_ases
bondages1237893bondages
borages103917163b_orages
boscages1366643boscages
boskage1465413boskage_
brakeages1643973brakeages
breakages1644273breakages
brewages1436383brewages
brockages1844783brockages
brokage1436673brokage_
bubales113513343bu_bales
bubkes144612623bubk__es
buckeyes1945263buckeyes
buckles153416093buck_les
buckoes153810393buck_oes
budges104820123bu__dges
bugbanes1345153bugbanes
bulge86419873bul__ge_
bulged105117123bul__ged
bulger94917353bul__ger
bulgers105215143bul__gers
bulked134216743bulk__ed
bulkier134111513bulk_ier
bulkiest143511263bulk_iest
bulkiness1555933bulkiness
bulks115920613bulk___s
bullace113410673bullace_
bullae83416163bulla_e_
bullate93415073bullate_
bullies94121893bul_lies
bulwarks1744133bulwarks
bunkmates1743673bunkmates
buoyage1344293buoyage_
bupkes144811483bupk__es
burgage1136633burgage_
burkas124513803burka__s
burkes124421313burk__es
burkites1436673burkites
butanes9312743bu_tanes
collages113514233collages
corkages1539103corkages
cubages1237923cu_bages
cuttages11297223cuttages
dockages1635983dockages
dunnages10154933dunnages
foliages1247623foliages
gulags837543gul_ag_s
haulages1236623haul_ages
leakages1334933leakages
linkages1385953linkages
lockages1536723lockages
luggages1143633luggages
meltages1148243meltages
milages103114403mil_ages
mileages11249693mileages
millages113212893millages
moulages1138053moul_ages
outages82317323ou_tages
outrages92215933outrages
packages17138733packages
pelages10714613pel_ages
pillages113012603pillages
plages94520153_pl_ages
plumages1335653plumages
pulsates1048813pulsates
quayages2144213quayages
rummages1344933rummages
salvages1238123salvages
selvages1236513selvages
silages82514443sil_ages
sinkages1386853sinkages
soakages1336143soakages
sulfates11310793sulfates
sulkies114315763sulk_ies
sullage859913sullage_
tallages92312003tallages
tankages13217113tankages
tillages93011243tillages
tollages92410193tollages
truckages1643523truckages
tunnages9195903tunnages
ukases10358063_u_kases
ullage739043_ullage_
ullaged937033_ullaged
uncages103213773_uncages
usages759603_u_sages
villages123010593villages
voltages1237253voltages
vulgates12237233vulgates

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.1531167915.0
2DLD Change Limit1461621157.20320291.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.40224140.9
 
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.