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

198 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
derms8502289(None) 
berms95323661berms
deems85421771deems
derm76031891derm_
derma84918511derma
dermas94116811dermas
dermis94717161dermis
dorms85723841dorms
germs85118871germs
herms105626431herms
perms95524511perms
terms75523471terms
adeems946332adeems
arms66137492_arms
barms96128462barms
beams95328172beams
bergs84718042bergs
berks115423122berks
berm86732752berm_
berme96022942berme
bermes106023002bermes
ceres75540012ceres
ceros74726072ceros
corms95626222corms
dams77444372d_ams
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
debris93311492debris
debs76530242de_bs
debts86418372debts
decks124822192decks
decos85522122decos
deeds75423762deeds
deem75432892deem_
deeps84921772deeps
deers64930522deers
dees56356632de_es
deets65330242deets
defis96717502defis
deforms1337802deforms
degas75119162degas
degerms1135622degerms
degums10438622degums
deils65722862deils
deism84116032deism
deisms94411042deisms
dekes105224452dekes
deles65139252deles
delfs94918672delfs
delis64928542delis
dells66630942dells
dels56745472de_ls
delts65731792delts
deme76536282de_me
demes86032692demes
demo77427552de_mo
demos86022992demos
demy105422852de_my
denes65639722denes
denims95214322denims
dens55945072de_ns
dents65031802dents
deperms1236602deperms
derat65044082derat
derats74625062derats
deray95024182deray
derays105514252derays
derby114715342derby
dere56845902der_e
dermal93614342dermal
dermic114511912dermic
derris73615272derris
derry94721372derry
desks105913072desks
devas96218882devas
devs86424032de_vs
deworms1338032deworms
dews86230602de_ws
dexes135224512dexes
deys85027472de_ys
dims75435022d_ims
dirams94413702dirams
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
doers65225712doer_s
doms76239572d_oms
dooms85321342dooms
dorks105724442dorks
dorm76834632dorm_
dormy115817472dormy
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doums85417642doums
drams86025832drams
dreams94513982dreams
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
drums85415872drums
drys86314802d_rys
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
durums948152durums
dyers96617132dyer_s
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
odeums9367312odeums
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.310576422.6
2DLD Change Limit538001981.64032804.9
3Display Results1981980.0503960.0
 (SQL Overall)1786911982.00089345.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.