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

181 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
nerds6571925(None) 
herds96424681herds
nards65928461nards
needs65719631needs
nerd56624941nerd_
nerdy95014701nerdy
nerts55924981nerts
nurds65518521nurds
bards87139642bards
beads85429502beads
beards94116672beards
beds75937782be_ds
bends85628972bends
bergs84718042bergs
berks115423122berks
berms95323662berms
birds85421332birds
burds84626062burds
cards85137932cards
ceres75540012ceres
ceros74726072ceros
cords86030622cords
creds85418772creds
curds85725612curds
deads75726912deads
deeds75423762deeds
derms85022892derms
eds46638922_e_ds
elds56324852_elds
ends56528522_ends
eras45441502_eras
ergs55523812_ergs
erns45428222_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
fards96629842fards
feds85234312fe_ds
feeds94921142feeds
fends96324972fends
feods99516852feods
feres86038182feres
ferns85220082ferns
feuds95914882feuds
fords95328182fords
geds66730812ge_ds
gelds75118342gelds
germs85118872germs
girds74816992girds
hards96435652hards
heads95127112heads
heeds95420422heeds
herbs105520502herbs
herd84933062herd_
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872her_s
hurds95219072hurds
inerts64517022inerts
jerids142810942jerids
jerks166514892jerks
kerbs115013672kerbs
kerfs125413572kerfs
kerns94719562kerns
kneads11357092kneads
lards65331862lards
leads66028492leads
lends65326252lends
leuds66214812leuds
lords64923502lords
meads85425322meads
meds75735362me_ds
meeds84920272meeds
melds84822382melds
mends84927692mends
mercs96020452mercs
merde84320122merde
merdes94518602merdes
meres75143572meres
merks114722402merks
merls77423902merls
narcs76122022narcs
nard56634452nard_
nares55544152nares
naris55735292naris
narks96026032narks
neaps75618322neaps
nears55529422nears
neats55931902neats
nebs66124982ne_bs
necks115119332necks
neddy10479872neddy
need54934152need_
needy94614692needy
neems77316292neems
neeps75617882neeps
negs55727362ne_gs
negus64513562negus
neifs85613042neifs
nemas75321572nemas
nenes55329672nenes
neons55818682neons
nerdish1137102nerdish
nereids838742nereids
nereis6315342nereis
nerol51017812nerol
nerols6914882nerols
nertz145117452nertz
nerve86617372nerve
nerves94216192nerves
nervy114610862nervy
ness45526562ne_ss
nests55728002nests
nets45941532ne_ts
netts55320722netts
neuks96510862neuks
neums75414252neums
neves87021872neves
nevus84611392nevus
news76127372ne_ws
newts86015282newts
nexus124710662nexus
nods55838222n_ods
noris54928272noris
norms76019302norms
nurd56224342nurd_
nurls55519682nurls
pards85634332pards
peds75835242pe_ds
pends85527192pends
perdu84216272perdu
perdus93711272perdus
perdy115417322perdy
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
reads64835272reads
redds74617832redds
reds56042862re_ds
reeds65430902reeds
rends65129952rends
sards64736182sards
seeds64330062seeds
sends65528242sends
seres55448892seres
serfs84922012serfs
sers45746652ser_s
sherds105614722sherds
sneds65715352sne_ds
sords64527802sords
surds65624662surds
teds54932572te_ds
tends65425582tends
terms75523472terms
terns55226872terns
turds65021692turds
urds55922422_urds
velds95615582velds
vends95520892vends
verbs104614392verbs
verts85724732verts
wards97734402wards
weds86628932we_ds
weeds95222212weeds
weirds10478052weirds
welds94719162welds
wends95822812wends
words95425072words
xerus12313332xerus
yards95324612yards
yerks125416562yerks
yirds96612512yirds
zeds145821802ze_ds
zerks185113822zerks
zeros144918102zeros

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.0762351197.4
2DLD Change Limit538001811.65632487.9
3Display Results1811810.0463934.8
 (SQL Overall)1786911811.778100501.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.