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

161 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
germs8511887(None) 
berms95323661berms
derms85022891derms
gems75329111ge_ms
germ75428961germ_
germy115113661germy
geums85414111geums
gorms85619591gorms
herms105626431herms
perms95524511perms
terms75523471terms
agers65027852ager_s
arms66137502_arms
barms96128472barms
beams95328172beams
bergs84718042bergs
berks115423122berks
berm86732752berm_
berme96022942berme
bermes106023002bermes
ceres75540012ceres
ceros74726072ceros
corms95626222corms
deems85421772deems
degerms1135622degerms
derm76031892derm_
derma84918522derma
dermas94116822dermas
dermis94717162dermis
dorms85723842dorms
egers65120372eger_s
elms67322702_elms
ems56435492_e_ms
eras45441502_eras
ergs55523812_ergs
erns45428232_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
farms106324962farms
fems96428702fe_ms
feres86038182feres
fermi103914162fermi
fermis114313502fermis
ferns85220082ferns
firms105217422firms
forms105327052forms
gams76648882g_ams
garbs86321412garbs
gars55750742gar_s
gaums86217072gaums
gears64628692gears
gecks125117092gecks
geds66730822ge_ds
geeks104915842geeks
gees55647882ge_es
gelds75118342gelds
gels56836102ge_ls
gelts65924612gelts
gem66840222ge_m_
gemma106311772gemma
gemmy135211052gemmy
genes65133092genes
genoms94412482genoms
genres75515622genres
genros74211332genros
gens55740072ge_ns
gents65729612gents
genus65319832genus
gerah9315302gerah
gerahs1039412gerahs
german9611992german
germans1079472germans
germen9612312germen
germens1078632germens
gests66028812gests
getas65421482getas
gets55442482ge_ts
geum75424552geum_
girds74817002girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
glams85822932glams
gleams94812252gleams
glims87417672glims
gloms85219782gloms
glums84621422glums
goers65520252goer_s
gores65740372gores
gorm75529392gorm_
gorps85316992gorps
grams85327312grams
grees65132472grees
greys96614852greys
gums75030942g_ums
gurus64318192gurus
gyms107514592g_yms
gyres94820322gyres
gyros95616482gyros
gyrus95310802gyrus
harms106829022harms
helms105619462helms
hems95534942he_ms
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herm95636152herm_
herma105318892herma
herns84825582herns
heros84930862heros
hers75844872her_s
jerks166514892jerks
kerbs115013672kerbs
kerfs125413572kerfs
kermes124616142kermes
kermis124012402kermis
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
warms107726862warms
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.326548131.9
2DLD Change Limit538001611.61033416.1
3Display Results1611610.0463500.0
 (SQL Overall)1786911611.98290156.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.