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

112 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
suffuse133544(None) 
suffused1544021suffused
suffuses1435831suffuses
diffuse1444372diffuse
effuse1234962_effuse
subfusc1444332subfusc
suffice15197572suffice
suffusive1852372suffusive
buffest15298643buffest
buffos14447853buffos_
buffs135519513buff_s_
confuse1238853confuse
cuffs135017493cuff_s_
defuse105712723_defuse
diffused1643483diffused
diffuser1543143diffuser
diffuses1534823diffuses
duffle13368533duff_le
duffles14308923duffles
duffs125216623duff_s_
dufus94010813du_fus_
dufuses11436593du_fuses
effused1434143_effused
effuses1335903_effuses
fuse76429993___fuse
guffs124414823guff_s_
huffish1935713huffish
huffs144514743huff_s_
infuse93110573_infuse
luffas12337483luffas_
luffs114516283luff_s_
muffle14339643muff_le
muffles153910453muffles
muffs134114213muff_s_
perfuse1247663perfuse
profuse1237153profuse
puffs134114933puff_s_
refuse94817513_refuse
ruffe114713813ruff__e
ruffes124112423ruffes_
ruffle124111673ruff_le
ruffles133512273ruffles
ruffs114516743ruff_s_
rufous948273rufous_
scouse84113633s_couse
scuffle15266893scuff_le
scuffles16287863scuffles
scuffs14419053scuff_s_
shuffle16276923shuff_le
shuffles17297783shuffles
sluffs12349583sluff_s_
snafus936743snafus_
snuffle13267833snuff_le
snuffles14318413snuffles
snuffs12358533snuff_s_
souffle13306803souff_le
souffles14298123souffles
souse56530773s__ouse
spouse84112513s_pouse
stuffs123810223stuff_s_
subbase1139323subbase
subcause1265823subcause
subduce12106983subduce
subdue9128493subdu_e
subdues1099893subdues
subfile122010503subfile
subfuscs1543753subfuscs
subrule939643subrule
subsume1146713subsume
succuss1134993succuss
sucrase9310343sucrase
sucrose939303sucrose
suffari1345503suffari
suffer124314513suff_er
suffered1536733suffered
sufferer1436063sufferer
suffers133113543suffers
sufficed17205663sufficed
sufficer16225823sufficer
suffices16208183suffices
suffix1935233suff_ix
suffixed22214343suffixed
suffixes21196353suffixes
sufflate1456183sufflate
suffrage1554523suffrage
suffusing1643533suffusing
suffusion1552773suffusion
sulcus8410493sulcus_
sulfas9311563sulfas_
sulfate10311653sulfate
sulfide1138103sulfide
sulfite10310473sulfite
sulfone1037483sulfone
sulfur937913sulfu_r
sulfured1236113sulfured
sulfuret1149273sulfuret
sulfurs1037343sulfurs
sulfury1345163sulfury
sulus54821883su_lus_
sunfast1038503sunfast
sunfish1338883sunfish
sunrise7310813sunrise
sunwise1036433sunwise
suppose1137973suppose
surbase939793surbase
surface1238653surface
surffish1744783surffish
surfs85022543surf_s_
surmise9311083surmise
suture6313203su_ture
tuffs115118263tuff_s_
unfused11319513_unfused

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271127.25018486.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.43624030.5
 
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.