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

115 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
chubs12541262(None) 
chub115516411chub_
chugs115511941chugs
chums125015831chums
clubs95415101clubs
cubs85832381c_ubs
hubs96027141_hubs
bhuts105812952bhuts
blubs95818152blubs
bubs86235502_bubs
cabs86739422c_abs
carbs96031462carbs
cauls75727772cauls
chads116122232chads
chais107530312chais
chams126028502chams
chaos105622862chaos
chaps125326062chaps
chars105936642chars
chats105730092chats
chaws135022462chaws
chays135319742chays
chefs136214662chefs
cherubs1434552cherubs
chess105016922chess
chews135418512chews
chias104625522chias
chics123920942chics
chimbs153910302chimbs
chins105631462chins
chips125721252chips
chis95933312ch_is
chits105424572chits
chops125019872chops
chows135618202chows
chubby1844122chubby
chuck164814872chuck
chucks174812932chucks
chufa13489112chufa
chufas14397672chufas
chuff164812492chuff
chuffs17427782chuffs
chug105914112chu_g
chum116318002chu_m
chump145315442chump
chumps154313822chumps
chunk144812382chunk
chunks154210332chunks
churl105913882churl
churls115411072churls
churn105113102churn
churns114910232churns
churr104512852churr
churrs115111512churrs
chute104316462chute
chutes114615772chutes
club85819472club_
clues74623032clues
cobbs115013992cobbs
cobs87043142c_obs
combs116122962combs
coups95522472coups
crabs95421392crabs
cribs94516752cribs
cruds85815852cruds
crumbs12409232crumbs
crus65828482cru_s
cub76940942c_ub_
cube85830212c_ube
cubes95028162c_ubes
cuds76730472c_uds
cues65438982c_ues
cups85430822c_ups
curbs94821652curbs
curs65645542c_urs
cuss65430612c_uss
cuts65841152c_uts
daubs85014562daubs
drubs85913832drubs
dubs78432192_dubs
flubs105515442flubs
fubs96328792_fubs
grubs86312602grubs
hobs97038982_hobs
hub86437482_hub_
hues75235232_hues
hugs86129752_hugs
hums96831422_hums
huns76136932_huns
huts76737442_huts
nubs65927142_nubs
phuts104613502phuts
pubs85029212_pubs
rhumbs13366772rhumbs
rhus75114052rhu_s
rubs66133492_rubs
schlubs1443192schlubs
schuls11299852schuls
schuss11186732schuss
scrubs104210312scrubs
shlubs11386732shlubs
shrubs11409212shrubs
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
slubs74719532slubs
snubs75412552snubs
stubs75016072stubs
subs66037122_subs
thuds95110132thuds
thugs95611992thugs
thumbs13377442thumbs
thus76721472thu_s
tubs65430062_tubs
whups134210002whups

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001151.54634799.5
3Display Results1151150.0303833.3
 (SQL Overall)1786911151.88994595.6
 
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.