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

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

33 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
bizarrenesses245200(None) 
bizarreness2251732bizarrene_s_s
barenesses12311703b__a_renesses
barrennesses1443433b__arrennesses
sizablenesses2445403sizablenesses
awarenesses1447254_awa_renesses
baronesses1238914b__a_ronesses
basenesses12310564b__a_senesses
beardednesses1744144b_eardednesses
biasnesses1236964bi_a__snesses
bitternesses1444534bitter_nesses
bizarreries22141574bizarr__eries
blearinesses1446544blea_rinesses
blurrinesses1484114b_lurrinesses
bravenesses1647954b_ra_venesses
coarsenesses1447244_coarsenesses
direnesses11311484di___renesses
diversenesses1754104diversenesses
fiercenesses1744314fi_ercenesses
hoarsenesses1545604_hoarsenesses
impurenesses16164434_impurenesses
inanenesses1149524_ina_nenesses
iratenesses11411444_ira_tenesses
largenesses1247554__largenesses
likablenesses1995444likablenesses
livablenesses18125844livablenesses
rarenesses10313114__ra_renesses
scarcenesses1644494_scarcenesses
sincerenesses1554734sincerenesses
sparenesses1339174_spa_renesses
sparsenesses1345804_sparsenesses
squarenesses2144974squa_renesses
tarrinesses11129084__tarrinesses

Search took 6 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 Filter178691950240.360496363.9
2DLD Change Limit95024334.75020005.1
3Display Results33330.0301100.0
 (SQL Overall)178691335.14034764.8
 
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.