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

179 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
bergs8471804(None) 
begs75733831be_gs
berg75425541berg_
berks115423121berks
berms95323661berms
burgs84924091burgs
ergs55523811_ergs
bags76645502b_ags
bangs85627772bangs
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barge85631022barge
barges94528252barges
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
beards94116672beards
bears75739042bears
beats76042242beats
beaus75127112beaus
becks135522012becks
bedrugs11194282bedrugs
beds75937782be_ds
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
befogs1246452befogs
beg65944132be_g_
beige81515372beige
beiges91014402beiges
beigy111110582beigy
beings94613032beings
belga8313232belga
belgas9311712belgas
bells76432162bells
bels66142492be_ls
belts75931162belts
bemas96424282bemas
bends85628972bends
benes75536232benes
bens65945702be_ns
bents76033692bents
beret74946362beret
berets85822522berets
berk105929842ber_k
berm86732752ber_m
berme96022942berme
bermes106023002bermes
berry104521772berry
berth104917882berth
berths114712422berths
beryl101211672beryl
beryls11107882beryls
bes56557432be__s
beses75830722beses
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442be_ts
bewigs1246532bewigs
beys913829552be_ys
biers76225222bier_s
bigs76235022b_igs
biogs85016112biogs
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
blogs85319232blogs
bogs75742752b_ogs
bongs87828422bongs
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
bourgs9459992bourgs
brags85625102brags
bras65746452b_ras
brees75632552brees
brens75823362brens
brews105617072brews
brigs85823222brigs
bris65539612b_ris
bros65635662b_ros
bugs76035912b_ugs
bungs85323862bungs
buras74736292buras
burbs95423492burbs
burds84626062burds
burg74930362burg_
burgh115216032burgh
burghs12519922burghs
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byres104421382byres
byrls105711232byrls
ceres75540012ceres
ceros74726072ceros
derms85022892derms
dregs76114862dregs
eggs66516152_eggs
engs56121392_engs
eras45441502_eras
erg45531072_erg_
ergo56420152_ergo
erns45428222_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
feres86038182feres
ferns85220082ferns
germs85118872germs
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872her_s
jerks166514892jerks
kegs95824012ke_gs
kerbs115013672kerbs
kerfs125413572kerfs
kerns94719562kerns
legs56133692le_gs
megs75530632me_gs
mercs96020452mercs
meres75143572meres
merge84523682merge
merges94122482merges
merks114722402merks
merls77423902merls
negs55727362ne_gs
nerds65719252nerds
nerts55924982nerts
peags86122842peags
pegs75531762pe_gs
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
regs55436572re_gs
rerigs74014792rerigs
segs54933882se_gs
seres55448892seres
serfs84922012serfs
serge64727462serge
serges74225962serges
sers45746652ser_s
teggs74710742teggs
tegs56031492te_gs
terga63315642terga
terms75523472terms
terns55226872terns
verbs104614392verbs
verge93419832verge
verges104320172verges
verts85724732verts
xerus12313332xerus
yeggs10608162yeggs
yerks125416562yerks
zerks185113822zerks
zeros144918112zeros

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 Filter178691538000.610292936.1
2DLD Change Limit538001793.70314528.8
3Display Results1791790.0931924.7
 (SQL Overall)1786911794.40640556.3
 
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.