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

54 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
poundage124402(None) 
poundages1344151poundages
bondage1138252bo_ndage
poundal1036402pounda_l
poundals1145012poundals
poundcake18101702poundcake
appendage1553343appendage
bandage11311023_bandage
blindage1243683blindage
bondages1237893bo_ndages
boundable1444843boundable
boundary1444753boundary
coinage10310553coin_age
cordage11310063co_rdage
courage10310993cou_rage
dunnage9175213_dunnage
inundate946043inundate
lounge75211213loun__ge
montage101211713mo_ntage
moulage1037903mou_lage
mundane1038073_mundane
nonage7313683no_n_age
nonwage1137163no_nwage
outage72017533_ou_tage
outdare83113403_outdare
outdate83016423_outdate
outrage82616893_outrage
pawnage1335873pawn_age
peonage1048723peon_age
plumage1245503plu_mage
plunge93811063plun__ge
plussage1143223plussage
portage103013643po_rtage
postage103214853po_stage
postdate1139653postdate
potage92715903po__tage
pottage103310603po_ttage
pounce105214093poun__ce
pound84417863pound___
poundcakes19102133poundcakes
pounded114112803pound_ed
pounder103314013pound_er
pounders113113293pounders
pounding123311473pounding
pounds93714383pound__s
roughage1344423roughage
soundable1245983soundable
soundstage1251323soundstage
sundae7312873_sunda_e
tonnage8168053to_nnage
tunnage8166373_tunnage
uncage93014873__uncage
windage1237933_windage
wordage1236503wo_rdage

Search took 9 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.420425454.8
2DLD Change Limit146162547.84618628.9
3Display Results54540.0134153.8
 (SQL Overall)178691548.27921583.6
 
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.