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 “brasses” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
brasses9381835(None) 
basses85428301b_asses
biasses94911651biasses
braises93818871braises
brashes124518461brashes
brassed103612371brassed
brassies103613531brassies
brisses94314311brisses
frasses104314511frasses
grasses84117341grasses
trasses74819321trasses
wrasses103812591wrasses
amasses93912852amasses
asses55629282__asses
baases85218012b_aases
badasses1136172badasses
bagasses1136312bagasses
bases75644352b_a_ses
bashes115631392b_ashes
basset85225382b_asset
bassets96414822b_assets
bassos85313702b_assos
bastes85330382b_astes
biases84618432bia_ses
biassed10418702biassed
blesses93812392blesses
blisses94911512blisses
bosses85925402b_osses
braces108427772bra_ces
braches144621222braches
braes75735052bra__es
braise84318752braise_
braised104014802braised
braizes183112452braizes
brakes124923122bra_kes
braless92910562braless
brasher124515242brasher
brashest133511762brashest
brasier94516752brasier
brasiers103710512brasiers
brasils9410972brasils
brass75428022bra_s_s
brassages1245262brassages
brassie93411522brassie
brassier103310532brassier
brassiest11369712brassiest
brassish1346432brassish
brassy11509232brass_y
braves115524082bra_ves
bravoes12418532bravoes
braxies16711462braxies
brazes175522192bra_zes
brises84927612br_ises
broses86524402br_oses
browses124712692browses
bruises93212912bruises
brushes124014662brushes
busses85023382b_usses
bypasses1533832bypasses
chasses124017502chasses
classes94717942classes
crases85532312cra_ses
crashes124618402crashes
crasser94114332crasser
crassest103411522crassest
cresses94219812cresses
crosses94220792crosses
dresses83716172dresses
drosses84513822drosses
erases64425402era_ses
eyasses10388022eyasses
fraises104215692fraises
gasses75724782_gasses
glasses84414272glasses
grassed93812792grassed
grosses84517682grosses
harasses11311032harasses
kvasses14365502kvasses
lasses64827592_lasses
masses85028712_masses
morasses1038902morasses
passes86030472_passes
praises94121102praises
prases84429022pra_ses
presses93523152presses
prisses94816712prisses
prosses94019512prosses
quasses16209502quasses
raises64826542_raises
rases55447212_ra_ses
rashes95330152_rashes
rassles73513922_rassles
sasses64124392_sasses
strasses81311442strasses
tasses64826762_tasses
trashes104119262trashes
tresses73719542tresses
trusses73813642trusses
urases63723562ura_ses
wrasse9398772wrasse_
wrassles11376712wrassles
zebrasses2043512zebrasses

Search took 4 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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711022.93636672.7
3Display Results1021020.0303400.0
 (SQL Overall)1786911023.10657530.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.