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

196 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
berms9532366(None) 
barms96128461barms
beams95328171beams
bergs84718041bergs
berks115423121berks
berm86732751berm_
berme96022941berme
bermes106023001bermes
derms85022891derms
germs85118871germs
herms105626431herms
perms95524511perms
terms75523471terms
arms66137492_arms
balms95723922balms
bams87044452b_ams
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barm86739602barm_
barmy125218762barmy
barns76335142barns
bars66564092bar_s
beads85429502beads
beaks115326622beaks
beam86939232beam_
beamy126218572beamy
beans75734692beans
beards94116672beards
bears75739042bears
beats76042242beats
beaus75127112beaus
becks135522012becks
bedims1149592bedims
beds75937782be_ds
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
begrims1276762begrims
begs75733832be_gs
begums11429492begums
bells76432162bells
bels66142492be_ls
belts75931162belts
bema85825252be_ma
bemas96424282bemas
bends85628972bends
benes75536232benes
bens65945702be_ns
bents76033692bents
beret74946362beret
berets85822522berets
berg75425542ber_g
berime105317332berime
berimes115216642berimes
berk105929842ber_k
bermed115217722bermed
berry104521772berry
berth104917882berth
berths114712422berths
beryl101211672beryl
beryls11107882beryls
bes56557432be__s
beses75830722beses
besoms105712732besoms
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442be_ts
beworms1437932beworms
beys913829552be_ys
biers76225222bier_s
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
blams95023852blams
booms95427122booms
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
bras65746452b_ras
breams104815042breams
brees75632552brees
brens75823362brens
brews105617072brews
brims94721622brims
bris65539612b_ris
bros65635662b_ros
bums85934592b_ums
buras74736302buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byres104421382byres
byrls105711232byrls
ceres75540012ceres
ceros74726072ceros
corms95626222corms
deems85421772deems
derm76031892derm_
derma84918512derma
dermas94116812dermas
dermis94717162dermis
dorms85723842dorms
elms67322702_elms
ems56435492_e_ms
eras45441502_eras
ergs55523812_ergs
erns45428232_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
farms106324952farms
fems96428702fe_ms
feres86038182feres
fermi103914162fermi
fermis114313502fermis
ferns85220082ferns
firms105217422firms
forms105327052forms
gems75329112ge_ms
germ75428962germ_
germy115113662germy
geums85414112geums
gorms85619592gorms
harms106829012harms
helms105619462helms
hems95534942he_ms
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herm95636152herm_
herma105318882herma
herns84825582herns
heros84930862heros
hers75844872her_s
jerks166514892jerks
kerbs115013672kerbs
kerfs125413572kerfs
kermes124616132kermes
kermis124012392kermis
kerns94719562kerns
mems85931502me_ms
mercs96020452mercs
meres75143572meres
merks114722402merks
merls77423902merls
neems77316292neems
nerds65719252nerds
nerts55924982nerts
neums75414252neums
norms76019312norms
peres76246642peres
peris75537072peris
perks115325802perks
perm85834632perm_
perps95521482perps
pervs105117372pervs
reams75729622reams
rearms85114652rearms
rems66237722re_ms
seams75731662seams
seems75525022seems
seres55448892seres
serfs84922012serfs
sers45746652ser_s
serums83916302serums
sperms102512602sperms
teams75726512teams
teems76019782teems
term66233152term_
terns55226872terns
therms115914872therms
verbs104614392verbs
vermes115019142vermes
vermis114214962vermis
verts85724732verts
warms107726852warms
worms105320762worms
xerus12313332xerus
yerks125416562yerks
zerks185113822zerks
zeros144918112zeros

Search took 3 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.360496363.9
2DLD Change Limit538001961.89028465.6
3Display Results1961960.0503920.0
 (SQL Overall)1786911962.30077691.7
 
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.