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

48 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
bluegrasses148175(None) 
bluegrass1242382bluegra_s_s
beargrasses1452643beargrasses
bentgrasses1452363bentgrasses
bluenesses1237933blue_nesses
bromegrasses1751483bromegrasses
cutgrasses1343573_cutgrasses
nutgrasses1143433_nutgrasses
ryegrasses1442463_ryegrasses
wiregrasses1552723wiregrasses
bagasses1136314b__ag_asses
biogasses1244004b_iog_asses
blesses93812394bl_e___sses
bluefishes1844314blue_fishes
bluenoses1144224blue__noses
bluffnesses1942774bluffnesses
bluntnesses1345394bluntnesses
brasses93818354b____rasses
buglosses1243544b_u_glosses
bunchgrasses2061124bunchgrasses
burgesses1245514b_urg_esses
burgraves1543444b_urgra_ves
buttresses1245664b_uttresses
cordgrasses1552124cordgrasses
crabgrasses1652024crabgrasses
cuirasses1144374_cu_irasses
degasses10278364__deg_asses
eelgrasses1142574_eelgrasses
egresses949444___egresses
eyeglasses1442264_eyeglasses
glegnesses1245074gl_egnesses
glueynesses1543704glueynesses
goosegrasses1461104goosegrasses
grasses84117344____grasses
hourglasses1552074hourglasses
knotgrasses1651534knotgrasses
megasses11307744__meg_asses
outgasses1036664_outg_asses
outgrosses1144784_outgrosses
pingrasses1343964_pingrasses
raygrasses1442844_raygrasses
regresses10310464__regresses
ribgrasses1342944_ribgrasses
sunglasses1143854_sunglasses
tallgrasses1252354tallgrasses
turfgrasses1551414turfgrasses
wineglasses1552124wineglasses
zebrasses2043514__zebrasses

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 Filter1786911488190.420425454.8
2DLD Change Limit148819488.56317379.3
3Display Results48480.0301600.0
 (SQL Overall)178691489.01319825.9
 
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.